link an excel field containing numbers and letters to access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Field Data Type for Linked Tables 8
autonumber queestion 3
Primary Keys Numbers and Characters 3
Data Type Issue in Linked Excel Table 7
Excel Sum numbers in cells that also contain text 34
Excel Convert word into numbers and back 4
Linking from Excel 2003 to Access 2003 3
Excel Use COUNTIF across a range of cells with formulas 0

Back
Top