B
Brenda from Michigan
I have read about the Type Mismatch error when an Excel workbook has alpha
and numeric data is in the same field and is imported into Access 2002. I
have a user with what appears to be straight data who gets the Type Mismatch
error when importing her worksheet into a newly created database. If the
database already exists, the sheet will import fine. The data is composed of
text, SS#, and dates.
I also have Access 2002 SP3 and am having no trouble importing the same
workbook as my user. This make me think some setting may be involved. Can
anyone shed any light on this for me. Thanks!
and numeric data is in the same field and is imported into Access 2002. I
have a user with what appears to be straight data who gets the Type Mismatch
error when importing her worksheet into a newly created database. If the
database already exists, the sheet will import fine. The data is composed of
text, SS#, and dates.
I also have Access 2002 SP3 and am having no trouble importing the same
workbook as my user. This make me think some setting may be involved. Can
anyone shed any light on this for me. Thanks!