aspose file tools
The moose likes JDBC and the fly likes Excel ODBC Data Sources - On the Fly?? Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Excel ODBC Data Sources - On the Fly??" Watch "Excel ODBC Data Sources - On the Fly??" New topic
Author

Excel ODBC Data Sources - On the Fly??

Chris Mann
Greenhorn

Joined: Sep 05, 2001
Posts: 1
Does anybody know whther it is possible to configure an Excel ODBC data source on the fly from Java. I would like to not have to have specifically set up a DSN pointing at an individual filename - but specify the filename at runtime.
Any help much appreciated.
jasonkosowan
Greenhorn

Joined: Sep 07, 2001
Posts: 25
I think that setting up an ODBC source is a type of security measure in Windows and, as such, may be out of reach of a Java application. Just a guess, though.
Originally posted by Chris Mann:
Does anybody know whther it is possible to configure an Excel ODBC data source on the fly from Java. I would like to not have to have specifically set up a DSN pointing at an individual filename - but specify the filename at runtime.
Any help much appreciated.

 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Excel ODBC Data Sources - On the Fly??
 
Similar Threads
jdbc
remove header in excel file generated by servlet
How to read from an excel sheet in linux?
Exporting html data to excel
Problem in retrieving Cell values from Excel file.