Access Import Problem

[patrickcre8]

I have an Excel:

Item 1
.....detaila
.....detailb
Item 2
.....detailc
.....detaild

And I would like to import into Access.

Question:
can I transpose the record so that it will be in a better format, like:
Item 1 detail a
Item 1 detail b....etc

 

[Ron_dK]

Make a query based on your table and insert qry field . e.g. :
FieldTest: Left([field1],6) .
Provided the text will always start with detail, you'll get :
detaila> a
detailb > b
detailxxx > xxx

etc.

 

[patrickcre8]

But the field is blank one.....any idea?

Excel sheets:
Item Item Desc Price Price Out Date
11040 MIRR SHUTTERED 38.5 69.99
P.O. # Status
52334 280
53074 280
53075 280
11041 MIRR SHUTTERED 38.5 69.99
P.O. # Status
52334 280
53074 280
53075 280

And I want to make it like:

11040 MIRR SHUTTERED 38.5 69.99 52334 280
11040 MIRR SHUTTERED 38.5 69.99 53074 280