Solved

Openning an excel database with ADO

Posted on 2002-06-28
4
230 Views
Last Modified: 2013-11-20
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).
0
Comment
Question by:skibud2
4 Comments
 

Author Comment

by:skibud2
ID: 7123577
For those who are looking for the answers to these questions, here they are:

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
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 8442045
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
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 10905354
PAQed, with points refunded (300)

Computer101
E-E Admin
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Shell script to login to remote m/c and execute commands 10 78
pre4 challenge 19 110
Problem to App 4 116
How do I get Window Title of all opened process? 4 32
Here is how to use MFC's automatic Radio Button handling in your dialog boxes and forms.  Beginner programmers usually start with a OnClick handler for each radio button and that's just not the right way to go.  MFC has a very cool system for handli…
Introduction: Displaying information on the statusbar.   Continuing from the third article about sudoku.   Open the project in visual studio. Status bar – let’s display the timestamp there.  We need to get the timestamp from the document s…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question