How to import Excel data into an MS Access Table

amunafc

Registered User.
Local time
Tomorrow, 01:31
Joined
Dec 17, 2009
Messages
62
GURUS, I have more than 80 Excel Spreadsheets, and I want to automatically import data to a particular table. I dont want copy and paste, but using any VBA Code or Macros or any command, e.g. if Excle A has 20 records, Excel B has 30 records, then Excel B should start from record 21 to 50 etc.:confused::confused::confused:
 
One of the options on the data import is to append records to an existing table.
 

Users who are viewing this thread

Back
Top Bottom