Beginner Question - Automation of Importing to Db

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Hi Steve - create an Append Query. You can then use it in a macro to run it
automatically.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing from excel issue with upgrade to office 2007 1
Create a new DB by importing from another DB 1
Import Users and Permissions? 1
Importing Data 2
import or query another db to get weekly data for a report 1
Import Wizard 3
Get internet leads into main DB 1
Access Access 2010 Backend DB Backup/Restore 0

Back
Top