Help for pull out data from excel!

D

Danny

I got excel sheet with client's data

Like this:

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
 

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

Help for pull out data from excel! 1
Help for pull out data from excel! 1
Pulling data from a linked SQL table 2
Pulling the town out of an address 5
Conditional update of main form from subform 1
Copy Data from 1 Sheet to Another 3
Select one checkbox to Add a Purchase Order (PO) Number 2
Generating Pivot Table from multiple worksheet 1

Top