Search code examples
ms-accesscsv

Import huge 550000+ row CSV file into Access

I have a CSV file with 550,000+ rows.

I need to import this data into Access, but when I try it throws an error that the file is too large (1.7GB).

Can you recommend a way to get this file into Access?

Solution

  • I'd either try the CSV ODBC connector, or otherwise import it first in a less limited database (MySQL, SQL Server) and import it from there.

    It seems that some versions of access have a hard 2GB limit on MDB files so you might get into trouble with that anyway.

    Good luck.