daily imports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have imported data from an excel worksheet to an access table.

i receive similar data from a report company on a daily basis.

is there a way to import these data to an existing access table without overwritting old data as may be accomplished with excel? i know that if i import new data access deletes and replaces old data in a table. could this be solved through a query?
 
1.
2.Use an "import-table" and an "archive table".
and use an append query to add data to the archive table.
use a delete query to empty the import-table before you
fill the new data.

-----Original Message-----
i have imported data from an excel worksheet to an access table.

i receive similar data from a report company on a daily basis.

is there a way to import these data to an existing access
table without overwritting old data as may be accomplished
with excel? i know that if i import new data access
deletes and replaces old data in a table. could this be
solved through a query?
 
Back
Top