Hi Brian,
I think when I import to a new table in Access it is trying to use a number.
This makes sense if the first 8 records in Excel are numeric, and then they become text with the
hyphens included. The wizard will make a best guess at the data type, depending on the first 8
rows. So, if you had something like:
23
45
52
34
95
49
87
21
9500-1
8678-02
You will end up with a numeric datatype that will choke on the 9th and 10th records. Rather than
let the wizard attempt to guess the best datatype, you can create the table in advance in Access,
and then specify this table as a step of the import wizard. Your Excel file will need to include
column headings, in order that the choice to use an existing table be available. The field names
in your Access table should match the column headings in the Excel file.
The following KB article includes some information you may find useful in the cause paragraph:
http://support.microsoft.com/?id=208414
Tom
______________________________
Tom, I made format in excel, text but How do I force access to take as text.
I think when I import to a new table in Access it is trying to use a number.
Can't figure out the problem
_______________________________
Hi Brian,
Importing Numbers 9500-1, 8678-02....
These are not numeric. They are text. Try importing into a text field.
Tom
_______________________________
Importing Numbers 9500-1, 8678-02 for example from Excel to Access and get
type conversion failure. What format do I need to use that would allow this
records to be imported to Access?
