Are you importing them into an existing table? Have you exported them from your accounting program? Are you creating a linked table to the accounting system?
Here is why I am asking. If you are importing them into an existing table then the error is coming from unlike data types. You are trying to insert an incorrect data type. Like trying to enter the letter z instead of a 1.
Yes, I have tried importing it into Excel and it seems OK.
These the steps I take.
Towards the end of every month I import these three tables into access by going to Access > import > ODBC Databases > Machine Data Tab and then select the Data Source > Select the tables I want imported. It has been working fine for the past few months.
The Accounting software has its data stored on a networkdrive and there is a ODBC Administrator Software that comes with the Accounting package. The ODBC Administration Software is where I create the connection to the accounting data and then create a DSN for the 3 tables I need to import into Access.