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.

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


"Steve" wrote:

> 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.

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

"Steve" wrote:

> 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.