This is more of a candidate for a custom import program instead of V/I. That's how I've done these before. But since everyone around here is Excel savvy (me excepted), what if you used that feature to insert a Named Range for each header field. E.g. OrderDate = C2, CustNo = C3, PONo = C4, BADDR = C7, BCITY = C8, etc. Then in a new tab / worksheet designate a row where each column references the named range. So A1 could be =OrderDate, A2 --> =CustNo, A3 --> =PONo etc. For the lines you do something similar. The point is the new sheet ends up looking more like a traditional data file that's V/I friendly. Then your import job can have the box checked for Header Separate from Line Record and in Records tab, tell it how to Skip records and how to ID a Header record.
Well I'm prolly blowing smoke but maybe this could lead to a better idea.
------------------------------
Alnoor Cassim
Free Agent Developer and Consultant
CallForHelp.biz
Email:
alnoor@callforhelp.bizOrange County, CA
------------------------------