how to import data from excel to sqlserver using java

You could use the JExcel API ( http://jexcelapi.sourceforge.net/). The import part depends a little bit on which sql server you use. Using PostgreSQL for example allows you to import files in CSV format, which possibly would reduce your programming task considerably.

abenstexa at 2007-7-28 19:05:00 >

thanks for ur reply..i m using POI for read the excel file..

i want to connect to the excel file thru sql server in java

can any one give suggestion

vrkrajeshrajua at 2007-7-28 19:05:00 >

There are a number of routes you can take.

You can export the data as CVS format (comma separated values) which is fairly easy for you java program to read,

You can use POI (available at Sourceforge) which provides an API to read xls files.

You can get a Java to COM+ package from the same place, and take the data from a running instance of Excel.

You can use the JDBC/ODBC bridge to read the spreadsheet as if it were a database.

In any case use JDCB to insert records into the MSSQL database.

malcolmmca at 2007-7-28 19:05:00 >