By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,433 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

Export data from old application to new application

P: n/a
Hi,

I have 2 versions of the same access application. The new version
contains more tables, forms, etc. but tables from old version have not
been modified. I have to copy the data users have entered in the old
applications into the new application.

I wonder what is the best way to do it. The tables to be updated in
the new version are empty.

My idea is to use append queries to export records. Is this the right
way ?
I've seen in some posts that it is a good advice to delete indexes
before exporting data, then recreate the indexes in the new tables.
Should I proceed like that ?

Are there any other points I should pay attention to ?

Thanks in advance.

Regards

Sep 5 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
bertil ,
a good way to transfer data from one data base to another is append
queries BUT you have to make sure the fields in your new database
tables have the same properties as the old - eg. "number" or "text".
also some fields may have to be allowed to be null otherwise errors
will come up all the time.
brino

bertil wrote:
Hi,

I have 2 versions of the same access application. The new version
contains more tables, forms, etc. but tables from old version have not
been modified. I have to copy the data users have entered in the old
applications into the new application.

I wonder what is the best way to do it. The tables to be updated in
the new version are empty.

My idea is to use append queries to export records. Is this the right
way ?
I've seen in some posts that it is a good advice to delete indexes
before exporting data, then recreate the indexes in the new tables.
Should I proceed like that ?

Are there any other points I should pay attention to ?

Thanks in advance.

Regards
Sep 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.