113k views
5 votes
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???​

I have a problem with importing excel file into Access. I have some table in Excel-example-1
User Cesarluis
by
8.5k points

2 Answers

4 votes

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.

User DDPWNAGE
by
8.7k points
3 votes

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

User Josep Espasa
by
7.5k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.