Home.... | log in.... | Pub my question! | Sign-up....
Java-index >> Database Connectivity >> Java Database Connectivity (JDBC)

Excel driver

Hello there!I am trying to make an Excel file to work like a database, but I don't know where can I find a driver for Microsoft Excel.I want to use the JDBC-ODBC bridge.Can anybody help me?Thank you very much,Rodica.
[245 byte] By [rodica_l_2000@yahoo.coma] at [2007-10-2 17:41:10]
«« Synchronisation Query - Urgent....pls rply
»» compiling package
# 1

> Hello there!

>

> I am trying to make an Excel file to work like a database,

Not a database that can easily be shared by many users. Excel spreadsheets are individual desktop items. I'm saying this just so you'll realize that Excel might be able to hold data in worksheets, but it's not an industrial strength relational database.

> but I don't know where can I find a

> driver for Microsoft Excel.I want to use the

> JDBC-ODBC bridge.Can anybody help me?

You can use the bridge if you want. You can also use a library like POI to read and write to Excel.

%

duffymoa at 2007-7-13 18:58:30 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

I just want to make a select from Excel(database) and return the result into an ResultSet becuase I must compare this result with another ResultSet extract from a database(a real database this time).So I want to use JDBC-ODBC bridge but I couldn't find a driver for Excel tha's why I am asking you where I can find a driver for Excel.

Look on this link: http://www.rgagnon.com/javadetails/java-0362.html. I want to do something like this.

I read something about POI, but I think that will be more helpful for me if I make Excel to work like a database because I will compare more easy the results.So, can you help me more?

Thank you very much.

rodica_l_2000@yahoo.coma at 2007-7-13 18:58:30 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3
The question doesn't make any sense. If you use the JDBC-ODBC bridge then you don't need an Excel driver. And I don't understand why you say you would like to do something like R閍l Gagnon's example. If you would like to do that, then go ahead and do it.
DrClapa at 2007-7-13 18:58:30 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
Java Database Connectivity (JDBC)

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified