Importing updated tables into tables that already exist

awigren

I just finished my database, and now I have to import the updated information into the tables that already exist so that all the links stay the same. I had a person in the office assisting me, but unfortunately they are out for the week.

They did leave directions though, They instructed me to right click on the table and select imprt and then follow the wizard. They did a test run and it worked on their computer.

The problem is, when I right click on the table, there is no "Import" button. Do I just have a different version of Access or do I import it from somewhere different? And if so, how do I import this data into my already existing tables?



Thanks

Jul 16 '08 #1

alkeshnayak

If The Target Table And Destination Table Are Having Same Structucet Then Use Simple Query

Insert Into <Target Table> Select * From <Destination Table>

Jul 17 '08 #2

Delerna

right clicking brings up a context menu. ie. the contents of the menu changes according to what it is you right clicked on.
By right clicking on a table you brought up the table context menu.
You actually want the tabledefs context menu

Try right clicking in an empty area of the window and not on a table.

Jul 17 '08 #3