Excel Link:Data Type Problem

[Guest]

I want to appologize first if this has already been asked. I linked an Excel
worksheet to Access 2003 as a table. A column in in the table coverts to
number number format when the cells in Excel are text. It says I am not able
to modify the properties of a linked table. This cause a type mismatch
error when I try to do a query. The column is a job code. There is a job
code table in which the code are in text format. How can I get the liked
Excel table to stay in text form?

 

[Douglas J. Steele]

You can't really, not without introducing artificial data into the
spreadsheet, which obviously could cause problems in your application.

What you can try, though, is creating a query and using the CStr() or
Format() function on the numeric field, thus explicitly converting it to a
string. You can then use the query wherever you would otherwise have used
the linked table.

 

[Guest]

This worked. Thank you

You can't really, not without introducing artificial data into the
spreadsheet, which obviously could cause problems in your application.

What you can try, though, is creating a query and using the CStr() or
Format() function on the numeric field, thus explicitly converting it to a
string. You can then use the query wherever you would otherwise have used
the linked table.