Forum Discussion
Error importing .csv file
Thanks. It errors when you have gone through the wizard and attempt to finish it and start the import.
13,000,000 rows? In a csv file.... I would have to do some research, but that sounds like it might be a factor. I am also suspicious about that number, because the maximum number of rows in an Excel worksheet would be 1,048,576. That means this csv file would be at least 12 times too large to have been saved from an Excel file.
Where is this file generated originally, by the way?
80 characters divided by 18 columns is about 4 to 5 characters per field. not a lot on that dimension.
In fact, thinking about it a bit more, I'm wondering if Access is really the right tool for a 13,000,000 row CSV file. Perhaps SQL Server, or another server database would be more appropriate.
