importing data into acess

[bkripper]

I am trying to import an access table into an existing access table. When I do this it just overwrites the existing. I have given both tables the same field names, so you would think access would figure out where to import the data to!

help!................greatly appreciated!!!!

tx,
Brian

 

[JennW]

Are you trying to replace your existing table or are you looking to append data to the current table?

Jenn

 

[lameid]

Sounds like you want to link to the table instead of importing it and then appending the data.

 

[JenDex]

If the tables are in the same Access database, you can also just write an append query. Might be the easiest way!

Good luck!

Jennifer