Import records to existing table

[sbg2]

Access 2000

This has to be an easy one but I can't seem to figure it out. I created a table by importing the structure from a .dbf file. Now I simply want to import other .dbf records from a bunch of .dbf files that have the exact same structure. How do Import these records into my existing table?

This should be a no brainer but I have spent an hour or so searching the help file and the internet.

 

[KeithG]

Go to file import and the wizard should walk you through it.

 

[sbg2]

Go to file import and the wizard should walk you through it.

There is no File>Import

The only option I seem to have is File>Get External Data>Import. This brings up the Import dialog box, there is no wizard. Whenever I select a file it automatically creates a new table, no option given to import data into an existing table.

-----------
After further testing I do get a wizard when I try to import the same data from a .tab file. Unfortunately I don't have an option on how the file is saved. The files are generated from the web as .dbf files. Am I to understand Access can Import a .dbf file as a new table and import the associated records from that file but can not just import the records into an existing file?

 

[sbg2]

Anyone? Ferris? Bueller?

It just doesn't make sense that you can import a .dbf file structure and the resulting records but then not be able to import more records into an existing table. Whats the deal?

 

[namliam]

Why not keep things in 1 thread?

http://www.access-programmers.co.uk/forums/showthread.php?t=108639

 

[sbg2]

Why not keep things in 1 thread?

http://www.access-programmers.co.uk/forums/showthread.php?t=108639

The other post is in the forum, and pertains to, VB code. While this post is an offshoot of the other post, in general it has nothing to do with VB code. Hence the General forum.