Question of the day – How do you import a CSV file in MS-Access, to edit and save it?
Answer – It is not as easy as you guys think. When you import a CSV file in MS-Access, it “links” a table to the underling CSV file in a Read-only mode. There is no way you can edit it and then save it back.
But here is a neat trick to make it editable – First you need to create an empty table with just columns and no data. A really quick way to create the table beforehand is to open the csv file and delete all data except for the header row. Now save it as a different csv file. Import the newly saved file and Access will create an empty table from it. Now import the real CSV file into that table. Access will bring (read – import) in all the data and will let you edit it.