Importing Spreadsheets

[harryodave]

Hi,

Does anyone have an idea of how to import a .xls spreadsheet into a mySQL server using JSP?

cheers,

Dave

 

[sedj]

Is the .xls on the server on which mysql is running or is it on some remote client somewhere ?

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[harryodave]

It is on the server, I am sure there is a command that I can use, not sure which one it is.

 

[sedj]

You will have to :

Load the image into a byte[] array using FileInputStream class.
Create a table in MySQL which has a BLOB field to hold the binary data whihch is the spreadsheet.
Use JDBC and the PreparedStatement class, and the setBytes() method (or maybe setBlob() if there are size constraints on setBytes()) to insert the binary data into the database.

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[stefanwagner]

*the image* ?
Perhaps harryodave likes to store rows of values into a database?

Then you would need something like the hsf-library from the apache-project.

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[sedj]

I don't mean an image, I mean the spreadsheet itself ! Must be losing it.

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk