Import huge 550000+ row CSV file into Access -


I have a CSV file with 550000+ rows, I have to import this data in access, but when I try I'm sorry that this file is too big (1.7 GB), can you suggest getting this file in Access?

Thanks,

Derrill

Trying to access the ODBC connector or otherwise importing it into a less limited database (MySQL, SQL Server) and importing it

It seems that in some versions of access hard on MDB files There is a limit of 2 GB, so you can also have trouble in it.

Good luck.


Comments

Popular posts from this blog

sql - dynamically varied number of conditions in the 'where' statement using LINQ -

asp.net mvc - Dynamically Generated Ajax.BeginForm -

Debug on symbian -