skibud2
asked on
Openning an excel database with ADO
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).
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).
Hi skibud2,
<Edited by SpideyMod>
An erroneous auto-delete was posted, we have corrected the problem. Please indicate recommendations and these will not be scheduled for auto-delete, but will be finalized within the standard week notice.
A recommendation of "PAQ with refund" has already been proposed.
CleanupGuy -- EE database cleanup volunteer
<Edited by SpideyMod>
An erroneous auto-delete was posted, we have corrected the problem. Please indicate recommendations and these will not be scheduled for auto-delete, but will be finalized within the standard week notice.
A recommendation of "PAQ with refund" has already been proposed.
CleanupGuy -- EE database cleanup volunteer
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
1. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q257819. This is for VB and can be translated to VC++. Look at the online msdn example for Openschema in visual c++.
2. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288343