Fix Microsoft Access Import Error for Rows Over 65,000 Characters
Question details
Resolve an Access text import or link error that reports a row contains too many characters.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Importing or linking a delimited text file to an Access database.
- Observed behavior
- Access reports that a row exceeds 65,000 characters even though the visible rows appear shorter.
Identify the source text file and determine its expected delimiter and text qualifier. If the file comes from another system, check whether you can correct and export the affected records again.
Correct malformed records in the source text file
Use this approach when Access treats multiple records as one oversized row or crashes before the import wizard opens.
An unclosed text qualifier or an unexpected line break can cause Access to combine records. Stray tabs, invalid characters, or incorrect delimiters can also disrupt how the file is parsed.
Open the source file in a text editor and examine records around any suspected error. Look for unclosed quotation marks, unexpected line breaks, stray tabs, and inconsistent delimiters.
In Excel, use Data > From Text/CSV to preview the file. Look for records that span unexpected rows or place values in the wrong columns.
Edit the malformed records in the text file or correct them in the source system and export a new file. Preserve the intended delimiter and text qualifiers.
In Access, select External Data > New Data Source > From File > Text File, choose the corrected file, and retry the import or link.

Verify Access text import settings
Use the import wizard when it opens successfully but the file is not being parsed as expected.
Inspect Delimited Data with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility, making it easy to move existing files. Use WPS Spreadsheet to review tabular data before returning to Access; it does not repair the Access import process itself.

Frequently Asked Questions
Why does Access report an oversized row when each visible line is short?
An unclosed text qualifier or unexpected line break can make Access interpret several lines as one record. Open the source file in a text editor and inspect quotation marks and record boundaries.
Where are the Advanced import settings in Access?
Start from External Data > New Data Source > From File > Text File. After selecting the file and entering the import wizard, choose Advanced to review the import specification.
What can I do if Access crashes before the wizard opens?
Open the file in a text editor or use Excel's Data > From Text/CSV preview to investigate malformed records. Correct or re-export the file, then retry the Access import.
Can the delimiter or text qualifier cause this error?
Yes. If the settings do not match the file, Access may parse records incorrectly. In the text import wizard, check the delimiter and text qualifier against the source file and review the preview.




