exporting...

[Miranda]

hi guys,

i'm using the transferDatabase event in a macro to transfer some data from
one database to another (i also delete the data from the first database).
everything works the first time...the data is exported correctly. However,
if i try to export a second lot of data, the first lot of data is not there.
how do i make it so that the data is saved into the 2nd database. I'm using
the second database as an archive database....

any help would be appreciated

thanks!
miranda

 

[Steve Schapel]

Miranda,

Exporting data via TransferDatabase results in an existing table of the
same name being over-written by the exported table. Whereas importing
data via TransferDatabase results in a new table with a number added to
the end of the table name. So one idea is to run the procedure from
within the archive database, and then use an Append Query to move the
imported data into the main table. Another option would be to link the
tables in the archive database, and then do away with the
TransferDatabase idea, just use an Append Query directly to move the
data to the archive tables.