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
 
I have tried to simulate your problem but I use Access 2k3 so the results may
be different. Stages

1 I set up the data in Excel
2 I Imported the data into Access from Excel using import on the file menu.
3 Resultant table named sheets1 (Just Lazy, didn't name the table.
4 Created a query based on the form
Ran the query, all PO numbers (12 and 123LOH) display so I don't get the
same problem as you. How are you importing to Access? I have noticed that 12
is stored in Excel as a number whereas 123LOH is stored as text (You will see
that 12 is right aligned and 123LOH is left aligned in Excell). What is the
field setting of your table for the field PO# showing "Text"?

Try clicking on the column PO# in Excel and format the column to text before
you import to Access This will be noticeable as all the numbers jump to right
alignment?

Please let me know how you get on????

--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.
 
Back
Top