Hi All,

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.

James Davidson.