I am new to access trying to import excel file to access but getting blank where cell '0123456
See attached yellow cell get blank , i have 80000 rows to import
Any idea
I am new to access trying to import excel file to access but getting blank where cell '0123456
See attached yellow cell get blank , i have 80000 rows to import
Any idea
Access will guess at the column types.
If you add text to a number field,you get blank.
What data type is the target field?
thanks
I sorted it out, the issue was the target field
Please mark the thread as solved if the issue has been resolved? Thanks
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks