CODEWITHSUNDEEP
ms-accesscsvimportms-access-2010ms-access-2013
MDIT
MDIT

Reputation: 1548

Importe large csv (>2Go) file into access 2010/2013

I'm trying to import a large file (>2Go) into Microsoft Access 2010/2013 but I really can't even start the process of importation.

When I choose the file and I validate, I get this error message: enter image description here

The message is in Frensh, and it means; the file doesn't contain any data or the file is very large.

Thanks for your help!

Upvotes: 1

Views: 3435

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123654

The upper limit on the size of a Microsoft Access database file is 2GB. Since a table must reside within a single file the upper limit on the size of an Access table is 2GB (less the overhead of the database file itself).

While you might be able to split the CSV file and import it into 2 separate tables (in 2 separate .accdb files), it would definitely be inconvenient and probably would be slow. You should consider storing your data in SQL Server Express, where the upper limit on the size of a database is 10GB.

Upvotes: 2

Related Questions