Unparsable Record Error when importing data from Excel (1 Viewer)

Babycat

Member
Local time
Today, 07:58
Joined
Mar 31, 2020
Messages
275
Hi Everyone

I realize that Unparsable Record Error occurs when importing data to a table that got field with data type: Attachment. I have made a fresh database with only one table named: Maintable, then try to import 3 rows of data from Excel file.
Seem new datas was imported correctly, but I got extra table name "..._ImportedErrors" as below screenshots.

My cornern are:
- Is there any potential issue with the table after data imported?
- How to avoid this error?

Thank everyone

Data import issue with attachment data type.png
 

June7

AWF VIP
Local time
Yesterday, 16:58
Joined
Mar 9, 2014
Messages
5,423
Don't see any issue with data that did import.

Don't include column D in import.
 

Babycat

Member
Local time
Today, 07:58
Joined
Mar 31, 2020
Messages
275
Hi June7.
Thank for your suggestion, but I really dont know how to exclude column D from import file.
Just delete that column?
Will Access look at column's name instead of the column order?

Anyway, will try to play around this.
 

June7

AWF VIP
Local time
Yesterday, 16:58
Joined
Mar 9, 2014
Messages
5,423
Since you are importing to an existing table, can't use import Wizard. Use a VBA procedure executing TransferSpreadsheet and specify a range to import.

Or yes, can modify spreadsheet first but that defeats automation. Why is that column in spreadsheet if there is no data?
 

Users who are viewing this thread

Top Bottom