reading data in excel files from client side

Hello Experts,

I want to build a website from which clients can upload data in the excel sheets they have into the sql server 2000 on the database server.

These excel files will be at the client machine from where they will upload all the data from the excel file to database server through this website.

Can you please help how to go about doing this.

[377 byte] By [deepak@stara] at [2007-11-26 16:30:15]
# 1

There are two open source projects that will help you out: Jakarta POI and JExcel. Both can serialize and deserialize Excel files to Java. You can also use the older ODBC-JDBC bridge, which can both read Excel files (albeit in a limited way with SQL syntax) and then output to your SQL Server.

- Saish

Saisha at 2007-7-8 22:54:42 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...