Fix: Access Cannot Open Database File (Corrupt or Unsupported Error)
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.

- 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.
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.
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.
Launch your Microsoft Access database. Navigate to the 'External Data' tab on the top ribbon.
Click on 'New Data Source', select 'From File', and then choose 'Text File' from the dropdown menu.
Click the 'Browse' button in the dialog box and locate your large CSV file.
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.
Click 'OK' and follow the standard wizard prompts to define delimiters and column headers, then click 'Finish'.

Verify File Integrity with a Spreadsheet Application
If linking the table also fails, the source file may contain genuine corruption. Opening it in an external application helps isolate the issue.
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. Open WPS Spreadsheet: Launch the WPS Office suite and select the 'Spreadsheet' module from the main dashboard.
- 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. 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.

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.




