Microsoft Access – Fix File import Truncation error

If you attempt to import a table to Access from a file and get the “ImportErrors” table/report created (see image below), you know your table did not import correctly.  

Let me briefly tell you why I got the error:
I tried to import a .dat file and convert it to an Access table. While importing, Access noticed that it was unable to import some of the fields due to an error, and notified us which fields we need to fix in an “ImportErrors” table/report (as shown below). Open the newly created table to see what the errors are with the import:

 


Import error table

Continue reading