Connect to excel sheet w/o saving it to server

I an excel file submitted to a jsp page that connect to the excel file and read from it like a database.

Right now I have to save the excel file to a physical location then connect to it ie:DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=e:/LocUpload.xls;DriverID=22")

I want to know if there is a way to just connect to the excel w/o saving it to the server.

Thank you,

Henry

[442 byte] By [geiz777a] at [2007-11-27 10:33:53]
# 1

Not if you plan to use ODBC, no.

DrClapa at 2007-7-28 18:25:25 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

hi ,how are you

you can use jakarta POI (API)

it is an API can connect to microsoft office files including Excel files

you can download the POI from this link

poi.apache.org

Message was edited by:

Huzlenut

Huzlenuta at 2007-7-28 18:25:25 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3

> hi ,how are you

> you can use jakarta POI (API)

> it is an API can connect to microsoft office files

> including Excel files

> you can download the POI from this link

> poi.apache.org

Or, better than POI, Andy Khan's JExcel:

http://andykhan.com/jexcelapi/index.html

%

duffymoa at 2007-7-28 18:25:25 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...