Fix Access 2GB Limit When Importing Large CSVs to SQL Server
Question details
The user needs to import a massive 9 GB CSV file into a SQL Server database without triggering the Microsoft Access 2 GB file-size limit error.

- Product
- Microsoft Access / SQL Server
- Device & OS
- not provided
- Scenario
- Automating a large data import process for a client who relies on a Microsoft Access front-end button to trigger the import.
- Observed behavior
- Microsoft Access triggers a 2 GB file-size limit error and fails the import, even though the data is being routed to a linked SQL Server table, because Access creates temporary local data during the process.
Before proceeding, ensure that the CSV file is placed in a network or local directory where the SQL Server service account has full read permissions.
Automate BULK INSERT via Access Pass-Through Query
Bypass the Access database engine entirely by sending a direct command to SQL Server. This is the best method if you need to provide users with a clickable button inside Access.
When MS Access processes a large CSV, it caches data locally, hitting its hard 2 GB physical file limit. By using a pass-through query, Access simply acts as a remote control, telling SQL Server to pull the file directly.
Place the 9 GB CSV file on a drive accessible to the SQL Server engine (e.g., C:\DataImports\massive_data.csv on the server).
In Microsoft Access, go to the Create tab, click Query Design, close the tables dialog, and click Pass-Through in the Query Type group.
In the SQL view, write your import command: BULK INSERT YourDatabase.dbo.YourTable FROM 'C:\DataImports\massive_data.csv' WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '\n', FIRSTROW = 2);
Open the Property Sheet for the query and set the ODBC Connect Str to point to your SQL Server database.
Use Access VBA to trigger this query behind a form button using DoCmd.OpenQuery "YourPassThroughQueryName".

Import Using SQL Server Management Studio (SSMS)
Use native SQL Server tools if you do not strictly require the operation to be executed from the Microsoft Access UI.
Discover WPS Office for Everyday Data and Document Needs
While massive database management requires specialized SQL tools, WPS Office provides a lightweight, highly compatible suite for your everyday document, spreadsheet, and presentation tasks without heavy subscriptions.
- 1. Download the installer: Visit the official WPS website and download the free installation package.
- 2. Install the software: Run the setup file and follow the on-screen prompts to install WPS Office on your device.
- 3. Open your files: Launch WPS Spreadsheet to easily open, edit, and save your standard CSV and XLSX files.

Frequently Asked Questions
Why does Access give a 2GB error when importing into a linked SQL table?
When you route an import through MS Access, the Access database engine processes the data locally and creates temporary cache files. This causes it to hit its hard 2 GB physical file limit before it can successfully pass all the records to SQL Server.
Will increasing my computer's RAM solve the Access 2GB file limit?
No. The 2 GB limit is a strict architectural constraint of the Microsoft Access file format (.accdb and .mdb). Adding more system memory (RAM) will not override this physical file limit.
Can I open a 9GB CSV file in a standard spreadsheet program?
No. Standard spreadsheet software, including Microsoft Excel and WPS Spreadsheet, has a strict row limit of 1,048,576 rows. A 9 GB CSV file contains hundreds of millions of rows and must be processed using database engines like SQL Server or big data tools.
What is the fastest way to import big CSV files into SQL Server?
The BULK INSERT SQL command or the BCP (Bulk Copy Program) command-line utility are the fastest methods. They operate directly on the server level, bypassing middle-tier client applications and significantly reducing import times.




