Combine text and numbers

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

Guest

I am trying to import an Excel 2003 spreadsheet into Access 2003 containing
product information. Within one of the columns I continually receive
(ImportErrors) on the Product Part number column. The reason is because some
part numbers contain (345-A or 345A or A123). Is it possible to "fix" this
somehow? All other columns import just fine. I checked my Excel format
prior to import and I have the Part number column set to "text" in hopes this
would fix the issue, but still no progress. Any help would be appreciated.
Thank you.
 
Since you already check the Excel spreadsheet before importing anyway, try
this cheap and easy method:

Create a bogus first record in the spreadsheet. Make sure that every field
is filled in with right the type of data. Alos make sure to start the problem
field out with an alphabetical character like "A123". After importing, find
and delete the bogus record.
 
Dan: I know not how your question was referred to me; I don't know; may be
you can answer my search? I need to know a method, to find on search, a
means of finding and delevering phone numbers/addresses?...Hope you find
yours...Tarry..
 
Back
Top