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

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

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