Updating table from Spreadsheet

  • Thread starter Thread starter Raj
  • Start date Start date
R

Raj

Hi! I have a spreadsheet from which I get my data to be
added in the datatable(in access). I imported the
spreadsheet to access to make a table.
Now the problem is that new records are added to the
spreadsheet everyday. That means I need to add those
records to my datatable too.
How can I add those records without duplicating the
records in my datatable.
What I did was I made a link table, linking it to the
spreadsheet and then I made an append query between the
linked table and the datatable which added the records to
the datatable.But with this the previous records which are
already there in the datatable gets added twice.
Please advice what should I do. The datatable has 8 fields
and it has an auto number field too. Thank you for any
help I can get.
Raj
 
I do this a lot but I purge the entire table and then re-
append the entire linked spreadsheet.

Note - This will cause problems if the table is part of a
relationship with referential integrity.

Hope this helps!

Howard Brody
 
Back
Top