Append query

  • Thread starter Thread starter p wilson
  • Start date Start date
P

p wilson

hello
i have a database in which i have a linked spreadsheet.
the spreadsheet gets updated using excel on a regular
basis (data gets added on to the end of a list). I want to
use an append query to copy the data from the spreadsheet
to a table in the database so that i have carbon copy data
in both the spread sheet and in a table in the database. i
have managed to set up an append query that pulls across
the data from the spreadsheet into the table. The problem
is that when i run the query again to update the table it
not only copies the new additions to the spreadsheet, but
it also copies the data that had already been pulled
across the last time the query was run. this leads to the
data being duplicated. What i want to know is there a way
of only updating data that has been added since the last
time the query was run
 
if you are using a number field, go to table design view
and pick one number field (like id# or something) and
edit the properties so where it says "indexed" changed
that to "Yes (No Duplicates)" and that should take care
of it.
-Rob
 
Back
Top