Launch Excel and open the spreadsheet you wish to load into Access. Verify that the spreadsheet's column names match the Access table's field names.

Learn how to export an Access database to Excel. When you export data from Access to Excel, Access stores the copied data in a file that can be open in Excel.

Looking through the Excel object library within the code editor's object browser may also be helpful.<BR><BR>If you've got access to the MS Office developer references, so much the better.<BR><BR ...

I got assigned to do a little MS office work today, which includes importing some big (1mb) excel spreadsheets into an Access database file, and I only know the basics for these two programs. When ...