Query Problem: Text with heading row

[patrickcre8]

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

 

[WayneRyan]

Patrick,

Your Excel Sheet looks more like a report then a data source.

I don't think you can import the data with TransferText or with
a saved import specification. I think you'd have to parse it
with some VBA code.

Wayne

 

[patrickcre8]

well...that's why I am writing. And you are correct, this is the report from my customer which I want to import into my database.