Type Conversion Failure

[Guest]

Basically, I have two columns: "Description" (a text field), and "Call
Number" (also a text field). The first spreadsheet I successfully imported
had only numbers for the "Call Number" field. The second sheet that failed
had "Call Numbers" that had numbers and letters (such as "B21"). Even though
I set the datatype to "Text", every Call Number with a letter comes up in
Access as a "Type Conversion Failure". As far as I can tell, I should switch
the Access field to "text", but I have already done so! I can't figure out
what else to do. Thanks so much for any help!

 

[tina]

since you mention "spreadsheet", i'll guess you're importing from an Excel
file. try opening the Excel file and Save As to a .txt File Type. when you
import a text file, the Import Wizard in Access allows you a great deal of
control over the how the data comes into the database. go through the wizard
to set up the import (if you're using A2003, you may need to click the
Advanced button in order to manipulate the incoming data fields.). suggest
you save the setup as an ImportSpecification if you're going to do
repetitive imports of the same data format.

just doublecheck the existing table in Access to make sure the data type of
the CallNumbers field is indeed Text.

hth