>Maybe this can get you going:
>
>http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=150437&SiteID=1


Thanks.

Any idea on how to get more from this ?

select * from [ORD$]

This sheet comes in with 2 cross tabs on the top.

I tried to Select Column list from [ORD$] but it can't see those on the front end.

So should I just nuke the initial rows until I hit my column header row? Or is there a better way? I'd be deleting 20 rows tops in the sheets that I have now.