• 1.6k
  • 86
  • 1.8k

Import excel spreadsheets into access db.

Apr 18 2024 4:56 PM

I am searching for a tutorial or code to help me understand how to import into an access db, to multiple tables from an excel spreadsheet with multiple sheets. The names for each sheet inside the excel spreadsheet corresponds to the names of each table inside the access db. So, I want to import the data from the 'UserAccount' sheet inside the excel spreadsheet to the "UserAccount' table inside the Access db, and so on thru multiple sheets to multiple tables.

Answers (3)