Want to read MS-Excel Sheet Throgh Xml and Store it into DataBase using JDBC

[Sanjay pts]

Hi
All
I have data as in MS-Excel Format.
Now i want to read that Excel Sheets using XML and then stored it into Database.
Can anybody tell me how can i go for this.
Thanks in advance
Sanjay

[Ajith Kallambella]

You may not be able to read the Excel data using XML since XML is an application. However, you can read the Excel data into an XML document.
Microsoft ODBC drivers can be used to extract data from the Excel spreadsheet. I am not very familiar with the XML support offered by Microsoft ODBC drivers. Your best bet would be to explore if they offer support for building resultsets in XML format. If not, you may have to write an application to translate the standard resultset to XML format. That is not very difficult either.
Good luck,


------------------
Ajith Kallambella M.
Sun Certified Programmer for the Java�2 Platform.
IBM Certified Developer - XML and Related Technologies, V1.