Originally Posted by
isladogs
Yes to both questions.
The best solution is to:
1. LINK to the CSV file
2. IMPORT the parts of the CSV data that you want to an intermediary table - sometimes called a buffer or staging table. This allows you to add a primary key field, modify datatypes if required and to discard any unwanted columns
3. Now use a combination of append and/or update queries (or the equivalent SQL statements in VBA code) to add that data to one or more local Access tables.
Once completed you can empty the intermediary table(s)
Finally as you are going to do this repeatedly each month, it will cause a lot of database bloat.
You may want to consider doing steps 1 & 2 in a separate 'side-end' database to overcome this issue
For info, the above process is done with 30 CSVs every night in one of my apps for schools. The whole process is automated and performed in the middle of the night using a scheduled task