MS Excel ODBC driver configuration in WSADv5.1

[Biswajit Biswal]

Hi all,

I am using an ODBC driver for MS Excel in my java program, that
communicates with the Excel spreadsheet. I am facing trouble in
configuring the driver in WSADv5.1.

please help.
Also suggest if there is any alternative to this approach.

tnx
Biswajit

 

[DJDaveMark]

Also suggest if there is any alternative to this approach.

tnx
Biswajit

I can suggest another aproach...

a "pure Java implementation of the Excel '97(-2002) file format" in
other words create the .xls files yourself, no need for drivers. Main
link here...

http://jakarta.apache.org/poi/hssf/index.html

A good description of the whole project can be found here...

http://www.regdeveloper.co.uk/2006/01/27/poi_tutorial/

Hope this helps.

DJDaveMark