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 d

Question

3 years ago

6

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 d

o 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???

Computers and Technology

2 answers:

olasank [31] · Answer 1 · 2022-03-10T22:15:22+03:00

olasank [31]3 years ago

7 0

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.

Vlada [557] · Answer 2 · 2022-03-10T20:04:10+03:00

Vlada [557]3 years ago

4 0

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