I export 3 CSVs from a data system and need to import them once a week into Access, replacing the existing data in all 3 tables each time I import. What is the best practice for how I should do this.
A few notes:
I do not keep the old data in the CSVs. When I export I replace the CSVs that have the correct names.
I was thinking about linking to the CSVs and simply reopening the DB. There was a reason I converted the links to tables, but I can't remember. It had something to do with the queries I was building. But if it will work, I can go with links.
I may build a query in the future that appends the old records to a different table for posterity, but that's another matter.
Best workflow for this type of process? Thanks!