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

[jansb000 <jan...@pl...>]

OpenOffice can read Excel files.
Since it is opensource you may be able to use their code.

----- Original Message -----
From: "Marc Heiligers" <ma...@e-...>
To: "'Louis Godio'" <lg...@ya...>; "dev-cpp-users-list"
<dev...@li...>
Sent: Thursday, January 09, 2003 8:34 AM
Subject: RE: [Dev-C++] EXCEL files as a datasource


> 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
>
>
> -------------------------------------------------------
> 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
>
> ================================================================
> Deze e-mail is door E-mail VirusScanner van Planet Internet gecontroleerd
op virussen.
> Op http://www.planet.nl/evs staat een verwijzing naar de actuele lijst
waar op wordt gecontroleerd.