• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

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

 
Ranch Hand
Posts: 357
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Sheriff
Posts: 5782
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!