Solved

Openning an excel database with ADO

Posted on 2002-06-28
4
237 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ORA-01403: no data found 43 116
Shell script to login to remote m/c and execute commands 10 81
VBA "SendKeys" Syntax for Multiple Keystrokes 7 133
fizzArray  challenge 1 117
Introduction: Load and Save to file, Document-View interaction inside the SDI. Continuing from the second article about sudoku.   Open the project in visual studio. From the class view select CSudokuDoc and double click to open the header …
Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
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.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Suggested Courses

710 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