Access Excel Linked Text and Number Issues

S

Scott

Question for Access and Excel XP (2002). I have linked an Excel Spreadsheet
(Database) to Access for updating and other special Access functions. The
Excel data contains a unique identifier (Key field) call Serial Numbers (SN)
that contains 13 characters. Some SN contain numbers only, while other SN’s
contain numbers and one letter i.e; 99923J143567. When linking the data
together Excel identifies the SN’d item as GENERAL, while Access pulls the
information in as TEXT. Access then adds a hash mark (‘) to the beginning of
each SN containing digits only (no letters) i.e; ‘99923J143467, thus making
the SN TEXT. This in turn causes problems when using the Vlookup function in
Excel, resulting in a no return value when entering a SN, unless the hash
mark (‘) has been included in the SN. If I remove the Hash Mark (‘) from the
Excel SN’s they will not show up in the Access linked database. I would
prefer not to separate this field if possible. Other then that I have tried
several methods and searched high in low in the MS Database for help with no
LUCK! Can anybody HELP me? Thank You!!!
 

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

Top