Using TransferSpreadsheet to import from Excel to Access with variable file names

[mmar]

I'm creating an Access application that will be used by a customer who needs to import a large number of Excel spreadsheets each month. I'm attempting to automate this process using VBA and TransferSpreadsheet. However, the file names for each Excel file will (and must for record keeping) be different so I'm trying to determine how to get Access to prompt the user to select the file in a file open dialog box. Is there a way to do this?

 

[SoftwareMatters]

Yes this can be done by using the file dialogue function. Check this out: How to display and to use the File dialog box in Microsoft Access