File Cannot Open

Fix: Access Cannot Open Database File (Corrupt or Unsupported Error)

Ayan MasoodAyan Masood Nov 2, 2026 869 views

Question details

The user is unable to open or import a large CSV database file into Microsoft Access, receiving an error message indicating the file is corrupt or unsupported.

How to Fix Access Corrupt or Unsupported File Error When Opening Large CSVs
Product
Microsoft Access
Device & OS
not provided
Scenario
Importing a very large CSV database file (approximately 1.3 GB) into a new Access table.
Observed behavior
Access fails the import process and reports that the file may be corrupt or unsupported, even though similar previous imports were successful.
Before you start

Verify that your computer has sufficient storage space and ensure your Microsoft Access application is updated to the latest version to prevent sudden import failures.

Solution 1Recommended

Create a Linked Table Instead of Importing

Linking directly to the data source is the recommended method for handling very large text files, as it bypasses the strict file size limits of an Access database import.

Microsoft Access databases have a strict 2 GB total size limit. Importing a massive 1.3 GB CSV file directly into a new table can easily push the database over this limit, triggering generic corruption or unsupported errors. Linking the table keeps the data stored externally while allowing full query access.

1
Open External Data Settings

Launch your Microsoft Access database. Navigate to the 'External Data' tab on the top ribbon.

2
Select Text File Source

Click on 'New Data Source', select 'From File', and then choose 'Text File' from the dropdown menu.

3
Browse for Your CSV

Click the 'Browse' button in the dialog box and locate your large CSV file.

4
Choose the Link Option

Under the options for how and where to store the data, select 'Link to the data source by creating a linked table' rather than importing it.

5
Complete the Link Wizard

Click 'OK' and follow the standard wizard prompts to define delimiters and column headers, then click 'Finish'.

Create a Linked Table Instead of Importing
Performance Tip: Linked tables do not consume space inside the Access database file. Any updates made externally to the CSV will automatically be reflected when you query the linked table.
Free Microsoft Office alternative

Inspect and Manage Large CSV Files Easily with WPS Office

While WPS Office does not feature a relational database tool like Access, WPS Spreadsheet is an incredibly powerful, lightweight alternative for viewing, formatting, and verifying massive CSV datasets before you process them. It opens large files quickly without freezing, ensuring your data is clean before database integration.

  1. 1. Open WPS Spreadsheet: Launch the WPS Office suite and select the 'Spreadsheet' module from the main dashboard.
  2. 2. Load Your Database File: Click 'Menu' > 'Open' and select your large CSV file. Use the text import wizard to assign the correct delimiters.
  3. 3. Verify and Clean Data: Scan the dataset for broken rows or formatting errors to ensure the file is completely clean before linking it back into Access.
Seamlessly open and verify Microsoft Office formats, including heavy CSV, XLSX, and DOCX files.Lightweight architecture handles large data sets smoothly, preventing crashes during file inspection.Completely free to download with a highly familiar user interface, requiring zero learning curve.Built-in data cleaning and formatting tools to identify and fix CSV delimiter issues quickly.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access say my CSV file is corrupt when importing?

Access typically flags a file as corrupt if importing the file causes the database to exceed its 2 GB size limit, or if the CSV file lacks proper delimiters and row structures, causing the import wizard to crash.

What is the maximum file size I can import into an Access database?

The absolute maximum size for an entire Microsoft Access database (.accdb or .mdb) is 2 GB. If importing a CSV pushes the total database size over 2 GB, the import will fail. Linking large files avoids this limit.

How does a linked table differ from an imported table in Access?

An imported table copies all the external data directly into the Access database file, increasing its size. A linked table simply creates a connection to the external CSV file, reading the data in real-time without taking up storage space inside the database.

Can I edit data in a linked CSV table using Access?

No. When you link a CSV or text file to Access, the linked table is treated as read-only. To modify the data, you must edit the original CSV file using a text editor or a spreadsheet application.