In Access all column data should be the same data type (number, text, etc.). Is there a way in Excel to verify that all data is the same type?
In Access all column data should be the same data type (number, text, etc.). Is there a way in Excel to verify that all data is the same type?
If you have it turned on background error checking will show up numbers stored as text, you can also use built in functions like ISNUMBER/ISTEXT.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks