469,934 Members | 1,873 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

Importing updated tables into tables that already exist

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?

Jul 16 '08 #1
2 1303
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
1,134 Expert 1GB
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

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Lumpierbritches | last post: by
7 posts views Thread by Trevor Best | last post: by
5 posts views Thread by Mike Collins | last post: by
4 posts views Thread by JJ | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.