Help for pull out data from excel!

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

I got excel sheet with client's data
For example:

Name PO# Order Qty Price Ordertime
David 12 1000 10000.00 1/2/2007
Tom 123LOH 200 500.00 1/12/2007



When I pull out the data from the sheet, I use MS-Access 2000 query to display the data, but the PO# column only show like "123LOH",
PO "12" shows "# NUMBER", I got a lot of number not showing up.

How should I do to show everything on the Access??

Thanks!

Dan
 
Dan,

This sounds like a data/field type problem. First make sure in Excel
that the PO# column has a type of text.

Then, when you import the data make sure the existing table you import
into has a data type of text for the PO# field.

OR if you are creating the table anew when you import, make sure the
data type settings are set to text for the PO# field at that point.

Diane
 
Back
Top