Import Errors (1 Viewer)

[markcrobinson]

I have a VB program that imports data from an excel file. There are frequent occurrences of fields that get truncated end, every time there is an import, Access creates and saves an ImportErrors table.
Every week I need to go into Access and delete all the ImportError Files.
Is there a way to prevent these from being created?

Thank you!

 

[isladogs]

You need to look at the data and determine which cause errors.
e,g, text field > 255 characters.

Usually a well designed import spec where you specify datatypes will fix that issue