Import a Excel file to a table

Jass7869

Registered User.
Local time
Today, 06:46
Joined
Aug 12, 2014
Messages
96
How do you import an excel to table..appended?? Using code. I am new to access. I have code to export and open an query into a excel file. Please help
 
Sorry maybe I wasn't clear enough. My boss wants a button in the DB to import my queried excel file into a table within the DB.
 
Jass7869 the method CJ_London refers top is able to import a spreadsheet into a table in your database.
From that import table you can do your checks and transform it into something that fits your existing table.

From a user perspective it will just be a button but there needs to be a whole lot more going on behind the scenes before it will work.
 

Users who are viewing this thread

Back
Top Bottom