Import Excel - Overwrite Previous Data - Keep Queries & Reports

G

Guest

Each month I receive the same spreadsheet with updated information. I want to import it into Access and replace last month's import but I don't want to lose the queries and reports I've built. I want those queries and reports to work on the new import. How do I do that?
 
J

Joe Fallon

Import to a temp table each time.
Then write a query to append the data to your real table.
Base reports and queries on the real table.
--
Joe Fallon
Access MVP



Alan said:
Each month I receive the same spreadsheet with updated information. I
Click to expand...
want to import it into Access and replace last month's import but I don't
want to lose the queries and reports I've built. I want those queries and
reports to work on the new import. How do I do that?
 

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

Importing Queries and Reports into a new database 3
Import data and update changed information 1
Importing All Forms, Reports, Queries, Modules 2
Data import to excel 1
how to import queries from Paradox to Access 1
Import Data to Excel but Keep Chart Format 1
Importing data from Excel into an existing Access table? 1
Import data from ODBC 1

Top