Access determines the data type by something like the first 10 columns. If you have mixed data but the first 10 or so are numbers, then access thinks the column is number and you will have a conversion error. The way around this is to put a ' in the first column or two and it will tell access...