File Cannot Open

How to Fix Microsoft Access Cannot Open a CSV File During Import

Chanuka GeekiyanageChanuka Geekiyanage Nov 4, 2026 870 views

Question details

The user encounters a Cannot Open Database error when attempting to import a CSV file into Microsoft Access, even though the file is within size limits and works on other devices.

How to Fix Microsoft Access Cannot Open a CSV File During Import Error
Product
Microsoft Access
Device & OS
not provided
Scenario
Importing external data from a CSV text file into a Microsoft Access database.
Observed behavior
A Cannot Open Database error appears at the final step of the External Data import wizard.
Before you start

Make a complete backup of your current Access database and ensure the CSV file is closed and not currently being used by another program like Excel or Notepad.

Solution 1Recommended

Verify Import Steps and CSV File Integrity

Ensure you are using the correct external data import wizard and that the CSV file itself is not corrupted or locked by another application.

Often, this error occurs not because the database is broken, but because the import steps are incorrect, or the CSV file is restricted by Windows permissions or encoding issues.

1
Use the correct import menu

In the Access ribbon, go to the 'External Data' tab, click 'New Data Source', select 'From File', and then choose 'Text File' instead of trying to open it as an ACCDB file.

2
Check file permissions and locking

Browse to the exact path of your CSV file. Right-click the file, select Properties, and ensure you have Read permissions. Close any other applications that might have the CSV file open to prevent file-locking conflicts.

3
Verify CSV encoding

Open the CSV file in a plain text editor to verify its encoding (UTF-8 is recommended) and check for consistent delimiters before attempting the import again.

Verify Import Steps and CSV File Integrity
File paths matter: Avoid importing CSV files from deeply nested folders or network drives with long path names, as this can sometimes trigger false access errors.
Free Microsoft Office alternative

Discover WPS Office for Seamless Data Management

While Microsoft Access handles relational databases, dealing with frequent Microsoft Office import errors can be frustrating. For data organization, analysis, and managing CSV files flawlessly, WPS Office provides a highly compatible, lightweight, and free alternative.

  1. 1. Download and install: Get WPS Office for free from the official website and install it on your device.
  2. 2. Open WPS Spreadsheet: Launch WPS Spreadsheet, which serves as a powerful alternative for managing data.
  3. 3. Manage your CSV files: Drag and drop your CSV file directly into the workspace to view, clean, and analyze your data seamlessly.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Lightweight software that avoids heavy system resource usageFamiliar user interface requiring no learning curveFree to use for everyday office productivity needs
QA img-9

Frequently Asked Questions

Why does Access say Cannot Open Database for a CSV file?

This misleading error often occurs if the CSV file is currently locked by another application (like Excel), if you lack read permissions for the folder, or if Access encounters an unrecognized encoding format during the import wizard.

What is the maximum file size Access can handle?

An Access database has a total size limit of 2 GB, which includes all data and objects. If importing a large CSV file pushes the database over this limit, the import process will fail.

How do I properly format a CSV for an Access import?

Ensure your CSV has a single header row with clean, distinct column names. Use standard delimiters like commas or semicolons, remove special characters from column titles, and save the file with UTF-8 encoding.