Import Multiple Spreadsheets

This example shows how to use the file dialog picker to select multiple Excel files for importing into new Access tables. This can of course be expanded upon to suit different needs, but the base idea is probably here. The base folder for the file picker is the C:\ drive, so the workbook folder must be put there in order for the function to pull data correctly. This was done using Access 2003 and .xls Excel files (spreadsheet type 9).