JDBC & Connection
I have been asked to create a program to process a number Excel files. I have been able to make a ODBC connection to a test Excel file, and this works a treat. However I do not want to force my client to go into ODBC and point it at a different Excel file for every one that he has to process.
Is there a way within code to point JDBC at an Excel file of interest? I can provide a means to my client to indicate which Excel file they wish to process, but getting the code to open an Excel file without a predefined ODBC connection is the challenge.
Any thoughts or suggestions would be greatly appreciated.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL