Importing Data

[semperfi]

Is there a way to import just the data from another Access database into the current one? I am working on updating and changing some fields in a copy of a functioning Access database.

My problem is that after I have made the changes to forms, etc, I want to load in the existing data from the original database. What I get is that it creates a dupe table such as customer1, from the original customer table. I don't want to create another table I just want to move the data from one table into another similar structured table.

I used to program in Paradox and it was a fairly simple procedure. Any help would be appreciated.

Thanks, Ken

 

[mark curtis]

you can do 2 things:

1) You can in your development db(not live), Delete all the tables except the system tables and then right click and import all the tables from the live db

or

2) You can in your development db(not live), Delete all the tables except the system tables and then right click and link all the tables from the live db

The difference is that import will bring a static copy of the tables in whereas linking will hav the tables at real time.