Import data into Tables of new DB

  • Thread starter Thread starter GeoffK
  • Start date Start date
G

GeoffK

Hi All,

As my DB is improved I need to import historical data into the new version
of my DB from the previous DB version.

This has not been an issue untill I gave other users a copy of my DB to use,
now that I am about to send them an updated version I realised the need to
import their historical data into the new version.

There is a total of 11 tables that require this import.

Is there a proceedure to do this.

Thanking you in Advance

GeoffK
 
generally speaking; to consolidate data from various dbs ; you need to have
them in one place so you can either link to their tables or import them into
one db;

but they are still separate tables; and so then you need to set up
AppendQueries to put data from one table to another...

In my past experience; it can be tricky to be sure not to append
pre-existing data - if they all started with blank virgin DBs that isn't an
issue but if they all started with some common records you don't want to
reimport those over and over....so you might have to do some duplicate
checking queries also

be sure you have a duplicate back up
 
Back
Top