JDBC and Excel
843854Apr 28 2003 — edited Apr 28 2003Yes, I know this has been asked before, but I've searched and found nothing relative.
I am planning a project that will be deployed via web-start, and will be accessing a MS SQL Server database. No problems here, I'll be using the JTDS drivers for this, but I'm also thinking of implementing the ability to "export" to an Excel spreadsheet, as Excel is used extensively here where I work, and it would be good for those who use this program to be able to view stuff in Excel offline (not in the program). My question is this. Can I just use the same JTDS drivers to do this, or will I have to load the JDBC-ODBC drivers and create a DSN-less connection (this I've found in the forums)? Can you have two different "database" connections in one program? Use the JTDS drivers for MS SQL, and then use the JDBC-ODBC bridge driver to connect to an Excel spreadsheet to write to? Is this feasible? Not looking for source code or anything, just doing some planning. Thanks in advance, guys!
James