Macro to "TransferSpreadsheet"

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I'm using a macro with Action "TransferSpreadsheet" to import data from
floppy disks collected off several laptops to a table in my db. This
usually works ok, i cant think of any other way to do it. The problem is
sometimes data (Records) is duplicated in the master db. I dont know why
this is happening. Is there a way to prevent duplicate records in the
master database...Randy
 
Randy,

You could try importing the records into a temporary
table, delete the records from the temporary table that
currently are in the main table, and then appending the
temporary table to the main table.

A similar alternative is to import the records to a
temporary table, use an append query that links the
temporary table to the main table looking for nulls in the
main table. I've always thought this was a slower method.

Mark
 
Could you clarify this a bit. You say to import the data to lets say a
temp. table that is basically identical to the main table, but with a
different name.
Then append the temp. table to the main table. How does this prevent
duplicate records....Thanks...Randy
 
Back
Top