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.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center