How do a populate empty access table with records from excel table?

sueviolet

Registered User.
Local time
Today, 20:13
Joined
May 31, 2002
Messages
127
Hi


I have a 2 tables: One that is empty (access table called Barriers) and one excel table that has records (also called barriers). They have similar fields.

Basically, i want the records from the excel table to be in the access table. I am in the process of populating an empty database from various data sources.

How can i most easily do this? Do the tables need to have matching fields?

Thanks for your help

Sue
 
If they have matching fields, you can use the TransferSpreadsheet Method/Action to do the append. If not, you can link to the Excel spreadsheet and then create an append query that selects columns from the linked Excel spreadsheet and appends them to the columns you select in the Access table.
 
Hello,

Could you let me know how link to the Excel spreadsheet and then create an append query that selects columns from the linked Excel spreadsheet and appends them to the columns you select in the Access table?

I have about 750 excel files(each file has one worksheet) in a directory to work on.

e.g. in English

1. link(import) a file at C:\Dir1\file1.xlsx (for example worksheet has 10 coulmns and 1000 2. rows and first column is ID)
3.Append selected rows and columns (if 1st column (ID) = AA or BB or CC, then copy (Append data at column 7 and 9)
4. loop until all 750 files are linked (imported)


Do you think we can do this with visual basic code?

regards,

WJ
 

Users who are viewing this thread

Back
Top Bottom