RE: [Dev-C++] EXCEL files as a datasource

[Marc H. <ma...@e-...>]

Glad I could help. Will you let us know if you get it right, and what you
had to do to make it work?

_____________________________
Marc Heiligers

-----Original Message-----
From: Louis Godio [mailto:lg...@ya...] 
Sent: 09 January 2003 12:32 AM
To: Marc Heiligers
Subject: RE: [Dev-C++] EXCEL files as a datasource



Thank You Marc. Your note contains valuable information for me

--- Marc Heiligers <ma...@e-...> wrote:
> Hi,
> 
> There is a OleDB datasource provider for Excel. The trick is in the 
> connection string which should be something like: 
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=F:\agasp\samp\excel.xls;Extended Properties=Excel 8.0;" where 
> the Extended properties give the version of Excel to use. You can use 
> ADO as well (as ADO simply wraps OleDB). You'll probably want to find 
> some kind of class library to do this. I know you can also use ODBC to 
> connect to Excel
> spreadsheets, but I'm not sure how.
> 
> Some information here:
> Using ASP to connect to Excel: 
> http://www.aspalliance.com/wisemonk/view.aspx?id=AD062502
> 
> A ADO wrapper for use with VC: 
> http://www.codeproject.com/database/adowraps.asp#xx356392xx
> 
> Some stuff on using ADO from VC: 
> http://www.mindcracker.com/mindcracker/c_cafe/ado/ado3.asp
> http://www.mindcracker.com/mindcracker/c_cafe/ado/ado4.asp
> http://www.mindcracker.com/mindcracker/c_cafe/ado/ado7.asp
> 
> Another ADO wrapper class:
> This one looks like it might be the easiest to adapt. 
> http://www.codeproject.com/database/aadoclass.asp#xx344668xx
> 
> I hope this helps,
> 
> _____________________________
> Marc Heiligers
> 
> -----Original Message-----
> From: Louis Godio [mailto:lg...@ya...]
> Sent: 08 January 2003 12:13 AM
> To: DEVCppUsers
> Subject: [Dev-C++] EXCEL files as a datasource
> 
> 
> 
> I trying to use DEV C++ (and the built-in compiler of course) to 
> access MS EXCEL files. The basic idea is to use an  EXCEL file as a 
> data source for my
> C++ code.
> 
> Any one have any ideas or experience on this matter ? Is it an easy or 
> complex thing to do ?
> 
> Any help would be appreciated
> 
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now. 
> http://mailplus.yahoo.com
> 
> 
> 
> -------------------------------------------------------
> This SF.NET email is sponsored by:
> SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! 
> http://www.vasoftware.com 
> _______________________________________________
> Dev-cpp-users mailing list Dev...@li...
> TO UNSUBSCRIBE: http://www.noicys.cjb.net/devcpp/ub.htm
> https://lists.sourceforge.net/lists/listinfo/dev-cpp-users


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com