Fix Unparsable Records When Importing a CSV into Access 2010
Question details
The user needs to import a headerless CSV from AutoCAD Electrical into Access 2010 without losing the first data row.

- Product
- Microsoft Access 2010
- Device & OS
- not provided
- Scenario
- Importing a headerless CSV exported from AutoCAD Electrical into an Access table.
- Observed behavior
- Access reports an unparsable record and skips the first data row, even when the header option is unchecked.
Open the CSV in a text editor and compare the first few lines, including their commas and quotation marks. Check whether a trailing comma represents an intended empty field before removing it.
Check the CSV structure and save an import specification
Use this approach to keep the file headerless while checking delimiter and field settings.
Open the CSV in a text editor and compare the first line with later lines. Check for an extra trailing comma, inconsistent field counts, or unbalanced quotation marks.
Edit any malformed rows in the CSV and save the file. Remove a trailing comma only if it creates an unintended extra field.
In Access 2010, select External Data > Text File, browse to the CSV, and choose an import destination. In the Import Text Wizard, select Delimited and choose the comma delimiter.
Leave First Row Contains Field Names unchecked. Review the preview and field definitions; use Advanced to check the delimiter, text qualifier, and data types.
In the Advanced settings, use Save As to save an import specification, then complete the wizard. Open the imported table and any import errors table to check the first record and error details.

Import a separate CSV copy with a header row
Use a temporary header row if the headerless file continues to lose its first record.
Review CSV Data with WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheet files and CSV data. It supports common Microsoft Office formats for easier migration, though it does not fix Access import errors or replace an Access database.

Frequently Asked Questions
Why does Access skip the first row of my headerless CSV?
Access may be interpreting the row as field names, or the file structure may be causing an import error. In the Text Import Wizard, confirm that First Row Contains Field Names is unchecked, then inspect the first line and the import errors table.
Should I remove a trailing comma from every CSV row?
Not necessarily. A trailing comma can represent an empty final field. Compare the rows and expected field count in a text editor, and remove it only if the extra field is unintended.
Where can I save an Access 2010 text import specification?
Start an import through External Data > Text File. In the Import Text Wizard, select Advanced, review the settings, and use Save As to name the specification.
What if the source software cannot use CSV headers?
Keep the original headerless export and add field names only to a separate copy for Access. Import that copy with First Row Contains Field Names checked.




