How to Fix Microsoft Access Cannot Open a CSV File During Import
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.

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

Import the CSV into a Blank Database
Bypass potential corruption in your current database by importing the data into a fresh Access file.
Run Compact and Repair
Use the built-in Access tool to fix potential database corruption that triggers false Cannot Open errors.
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. Download and install: Get WPS Office for free from the official website and install it on your device.
- 2. Open WPS Spreadsheet: Launch WPS Spreadsheet, which serves as a powerful alternative for managing data.
- 3. Manage your CSV files: Drag and drop your CSV file directly into the workspace to view, clean, and analyze your data seamlessly.

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.




