daily imports

A

angie

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?
 
J

JohnQ

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
Click to expand...
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Appending an existing table with imported Excel data 0
Import excel file automatically that results in 2 tables 1
Refreshing Data Daily From a Linked Excel Spreadsheet 2
Sort on 3 columns when number of rows vary daily 1
Import Excel 2010 table into Access 2010 - not listed as range 0
Importing excel spreadsheet with changed data 1
Looking for Information Word (Office 365) editing using VB.Net 1

Top