Solved

Openning an excel database with ADO

Posted on 2002-06-28
4
220 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

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

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

Suggested Solutions

Introduction: Database storage, where is the exe actually on the disc? Playing a game selected randomly (how to generate random numbers).  Error trapping with try..catch to help the code run even if something goes wrong. Continuing from the seve…
Introduction: Dialogs (2) modeless dialog and a worker thread.  Handling data shared between threads.  Recursive functions. Continuing from the tenth article about sudoku.   Last article we worked with a modal dialog to help maintain informat…
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.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

803 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