MrExcel Publishing
Your One Stop for Excel Tips & Solutions

ID numbers without colon to export to Access.

Posted by Fred on November 13, 2001 7:12 AM

I've got a list of items with their respective ID number. The ID can be numeric (2569, 00279) as well as alphanumeric (INT00326). For those numbers that start with a 0, a colon (')is inserted so that the 0's are preserved. Unfortunately when I tried to import this list within Access, it causes an error due to "'". How can I format my list of ID number so that the import within Access goes without error? Thanks for your help.

Posted by Mark W. on November 13, 2001 8:09 AM

Don't use a colon -- format as Text instead (nt)

Posted by Mark W. on November 13, 2001 3:45 PM

Just for the record -- it's an apostrophe; not a colon (nt)