Question

I have a problem with importing excel file into Access. I have some table in Excel and I want to import it into Access. When I do everything I have to do the data from some column (field) just disappears and then I have two tables in Access; for example Stationery and Stationery_import errors. Why it happens and how can I fix that problem???​

Answer 1

As the poster mentioned in the comments, one data field had the wrong data code (integer instead of long integer). When the data is imported to Access, there is a data mis-match; causing the import error. The poster did a good job in identifying the cause.

Answer 2

need 2 describe exactly how u did the import when u had trouble.

my suggestion is to export from excel as txt or csv file format 1st; then import the txt or csv file to Access