Import Excel - Overwrite Previous Data - Keep Queries & Reports

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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?
 
Back
Top