Hi, Tek-Tippers! My Access 2007 database insists on importing text columns from a .csv import as numbers, causing much of my import to fail. I have tried creating a specification file but I'm only allowed fieldname and skip Y/N. I've never seen this limitation before. The table I'm importing to clearly has TEXT as the data type.
I cannot sort the .csv to put the alpha characters first because I have this issue with several columns; the one I sort imports fine and the other ones fail.
I read thread181-1492957 but didn't see anything in it that would help, and it's from 2008. Have there been any breakthroughs on this issue? Any assistance appreciated!
Michelle Hakala
I cannot sort the .csv to put the alpha characters first because I have this issue with several columns; the one I sort imports fine and the other ones fail.
I read thread181-1492957 but didn't see anything in it that would help, and it's from 2008. Have there been any breakthroughs on this issue? Any assistance appreciated!
Michelle Hakala