Click here to Skip to main content
15,916,030 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralDS problem Pin
Mihail5-Jul-01 6:02
Mihail5-Jul-01 6:02 
GeneralRe: DS problem Pin
Carlos Antollini5-Jul-01 6:17
Carlos Antollini5-Jul-01 6:17 
GeneralRe: DS problem Pin
Mihail5-Jul-01 6:54
Mihail5-Jul-01 6:54 
Generalado and excel Pin
Gérald Mercet5-Jul-01 5:39
Gérald Mercet5-Jul-01 5:39 
GeneralRe: ado and excel Pin
User 98855-Jul-01 6:16
User 98855-Jul-01 6:16 
GeneralRe: ado and excel Pin
Carlos Antollini5-Jul-01 6:26
Carlos Antollini5-Jul-01 6:26 
GeneralRe: ado and excel Pin
5-Jul-01 21:41
suss5-Jul-01 21:41 
GeneralRe: ado and excel Pin
User 98856-Jul-01 12:07
User 98856-Jul-01 12:07 
Instead of using the ODBC driver for ADO, you can also use the -
Microsoft.Jet.OLEDB.4.0 provider and use Engine Type as "Excel 8.0". There are examples in MSDN that does that, but they are mostly VB examples.

But, with ODBC driver, your code will be much easier as you can use "DSN=DataSource;" as the connect string for the ADO Recordset open.

Note: I have never used Excel through the Jet ADO driver. So I am not sure of the syntax.

Personally, I prefer using OLEDB over ADO in VC++. I use the OLEDB consumer templates. If you want to check this out you can look in MSDN for

CDataSource
CSession
CDynamicAccessor

classes.

-- Thomas

modified 29-Aug-18 21:01pm.

GeneralRe: ado and excel Pin
5-Jul-01 7:23
suss5-Jul-01 7:23 
QuestionHeader notifications? Pin
5-Jul-01 4:53
suss5-Jul-01 4:53 
AnswerRe: Header notifications? Pin
Tomasz Sowinski5-Jul-01 5:15
Tomasz Sowinski5-Jul-01 5:15 
GeneralRe: Header notifications? Pin
9-Jul-01 5:03
suss9-Jul-01 5:03 
QuestionHow can I hide a list control item? Pin
5-Jul-01 2:50
suss5-Jul-01 2:50 
AnswerRe: How can I hide a list control item? Pin
Tomasz Sowinski5-Jul-01 4:06
Tomasz Sowinski5-Jul-01 4:06 
QuestionHow to Print data in MSFlexgrid control in an VC++/MFC Application? Pin
Aky5-Jul-01 2:43
Aky5-Jul-01 2:43 
Generalado Pin
Gérald Mercet4-Jul-01 22:23
Gérald Mercet4-Jul-01 22:23 
QuestionHow to change File Icon Pin
Muhammad Abid4-Jul-01 22:18
Muhammad Abid4-Jul-01 22:18 
GeneralRequest for Application skeleton code Pin
N.Bharadwaj4-Jul-01 18:58
N.Bharadwaj4-Jul-01 18:58 
GeneralSpec reqd for driver development Pin
N.Bharadwaj4-Jul-01 18:46
N.Bharadwaj4-Jul-01 18:46 
GeneralCatching Access Violations Pin
Nick Blumhardt4-Jul-01 16:27
Nick Blumhardt4-Jul-01 16:27 
GeneralRe: Catching Access Violations Pin
Nick Blumhardt4-Jul-01 17:42
Nick Blumhardt4-Jul-01 17:42 
GeneralActiveX controls in Internet Explorer Pin
Derek Waters4-Jul-01 16:21
Derek Waters4-Jul-01 16:21 
GeneralRe: ActiveX controls in Internet Explorer Pin
Michael Dunn4-Jul-01 16:26
sitebuilderMichael Dunn4-Jul-01 16:26 
GeneralRe: ActiveX controls in Internet Explorer Pin
Derek Waters5-Jul-01 14:52
Derek Waters5-Jul-01 14:52 
GeneralClassWizard "new Class from type lib" help Pin
4-Jul-01 14:01
suss4-Jul-01 14:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.