link an excel field containing numbers and letters to access

I

islander

When I try to link excel table to acess it comes up as an error in any cell
that contains a number and letter togeether. ie. 102A.
 
D

Doug M

It seems like Access assumes the column is a number if the first entries
can be formatted that way. If you put an apostrophe (') in front of the
values in that column in Excel, then Access reads them as text.

Doug
 
Top