I have mixed data in a record (column) such as PA123 and 10234. When I import two different worksheets into Access from Excel, I get type conversion errors. What is the best was to format these columns to avoid errors. I use Access to compare the data from one spreadsheet to another. The data above represents position number in my organization and some positions start with the alpha characters and some with just numeric numbers. I formatted the columns as "text" prior to importing but one spreadsheet imports that column as "number" (even though I formatting it as text. and the other comes in as text--so I get a type mismatch and the import deletes records.