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