Forum Discussion
Error importing .csv file
Hello, I am trying to import a .csv file to access that is ~800 MB and I am getting an error stating the following: "cannot open database ". it may not be a database that your application ...
Two other thoughts about ways to manage this.
1) Have you tried simply linking to the csv without trying to import it? Can you do that and read the data?
2) Other methods for importing csv files might be more effective, albeit probably not very efficient with 13,000,000 rows. Look into approaches using the File Scripting Object.