Data Import & Export

Fix Access 2GB Limit When Importing Large CSVs to SQL Server

Jason MillerJason Miller Oct 28, 2026 869 views

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.

How to Import a Large CSV into SQL Server Without Access 2GB Errors
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 you start

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.

Solution 1Recommended

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.

1
Store the CSV file correctly

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).

2
Create a Pass-Through Query in Access

In Microsoft Access, go to the Create tab, click Query Design, close the tables dialog, and click Pass-Through in the Query Type group.

3
Write the BULK INSERT statement

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);

4
Configure ODBC Connection

Open the Property Sheet for the query and set the ODBC Connect Str to point to your SQL Server database.

5
Create an execution button (Optional)

Use Access VBA to trigger this query behind a form button using DoCmd.OpenQuery "YourPassThroughQueryName".

Automate BULK INSERT via Access Pass-Through Query
Performance Tip: Test your BULK INSERT command with a small 5 MB subset of your CSV file first to verify column mappings and server permissions.
Free Microsoft Office alternative

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. 1. Download the installer: Visit the official WPS website and download the free installation package.
  2. 2. Install the software: Run the setup file and follow the on-screen prompts to install WPS Office on your device.
  3. 3. Open your files: Launch WPS Spreadsheet to easily open, edit, and save your standard CSV and XLSX files.
Seamless compatibility with Microsoft Office formats (docx, xlsx, pptx, csv)Free and lightweight alternative to heavy Office suitesRobust spreadsheet tool for standard CSV review and data analysisFamiliar user interface requires no learning curve for seamless migration
microsoft office alternative - wps office

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.