Import from another database

Muzicmn

Registered User.
Local time
Today, 14:08
Joined
Nov 3, 2002
Messages
78
Not sure where to post this question, so I put it in the general section,

I have an old db that i would like to import into a new be db of a newer version i wrote of this db. Is there any way something like an append query will add the records from one database to another?

or do i have to import then append then delete?

I have read several posts on this forum reference importing but all of them are from excel spreadsheets. Can this even be done??

Ricky
 
In your new Db, go to File> get external data> import and select the old Db.
In fact you can import any object from your old Db, but in your case I would import the tables only. Just make sure that the tables of the old DB do not have the same name as in the new one.
Once imported, you can copy the table data from one table to the other.

Hope this helps.
 
Open the old Db with your latest version. It should ask you whether you want to convert.

Else you could try Tools-> Database Utilities-> Convert Database, and then select one of the formats.

HTH

Dave
 
Scratch that if your new Db has different forms etc. One thing I have done, if the tables are the same in both Db's is to delete all the tables from your new Db and the import the new ones as suggested by Rak. Another way to to this is to open both Db's and simply drag and drop the old tables into your new Db.

Dave

(PS... Dont forget to make backups first !)
 
Sounds like what i have to do, i was hoping there was a way to automate the process.

The problem really lies in the fact that this program is being run on thumb drives and depending on the configuration of the computer its plugged into the drive name changes (in some instances its drive e others its drive f etc...) so splitting the db into a backend wont work because the linked table manager must be run depending on the computer. pain. I would like to split it but dont think thats a happening thing.

I guess I need to write a code that will do just that, delete the current table structure on the new one and import the old one....

anyother ideas before i head off in that direction??

Ricky
 

Users who are viewing this thread

Back
Top Bottom