Beginner Question - Automation of Importing to Db

[Guest]

I am using Access 03. I have a 1,000 line db in which I am trying to automate
the importing/appending of additional data. Duplicates are not a problem.

From what I have read the best way to do this is using a macro. The excel
file that want to append to the db has the same headers as the database. I
want to be sure before I try importing that I do not overwrite my existing db.

Does anyone have any suggestions. Thx.

 

[Guest]

Steve:

What would probably be better would be to set up an Import Specification,
and then reference it through VBA.

Check the help files, for more information.

Good luck.

Sharkbyte

 

[Guest]

Hi Steve - create an Append Query. You can then use it in a macro to run it
automatically.