I am openning an excel database with ADO.
I have two problems. An answer for either will receive the points.
1. How do I get the list of sheets that are available in the excel file?
2. How do I make it so that when I query the sheet, the first row is not turned into column headings? I do not want to do any registry editing (I don't know if this is feasable).