Data Import & Export

Fix Microsoft Access Import Error for Rows Over 65,000 Characters

Camila MilosovichCamila Milosovich Nov 14, 2026 868 views

Question details

Resolve an Access text import or link error that reports a row contains too many characters.

Fix Microsoft Access Import Error for Rows Over 65,000 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.
Before you start

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.

Solution 1Recommended

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.

1
Inspect the text file

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.

2
Check the file in Excel

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.

3
Correct the affected data

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.

4
Retry in Access

In Access, select External Data > New Data Source > From File > Text File, choose the corrected file, and retry the import or link.

Correct malformed records in the source text file
Check the original file: A spreadsheet preview can help locate unusual records, but a text editor may make quotation marks and line breaks easier to inspect.
Free Microsoft Office alternative

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.

Review tabular data in a familiar spreadsheet interfaceOpen and work with Microsoft Excel XLS and XLSX filesUse a free, lightweight Office alternativeMove existing Office documents into a familiar workspace
microsoft office alternative - wps office

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.