I'm in the middle of creating an Access DB. The table data will be imported from various Excel Spreadsheets. I'd like to automate the imports of these spreadsheets. I'm aware that I'll need to use the TransferSpreadsheet method, however, the imports will be ongoing, and I'd like the use to have control over which spreadsheets are imported and when.
That is, I'd like to, on a button's onClick event, have a File Open dialog box open, allow the user to select the file name of the Excel spreadsheet to be imported, and then have that file name passed back into the TransferSpreadsheet method as a parameter. Any ideas on how I can do so?