• Post Reply Bookmark Topic Watch Topic
  • New Topic

extract data from xml file and send to database table  RSS feed

 
carlos flamenco
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
I have to extract certain values (dates,id's names) from an index.xml and send the values to a table in a database.
The values appear in the xml file as:
Date="Date_value"
iditem="id_value"
or as
<name>name_value</name>
What would be the best way to go about this?
The xml file is quite large and will be queried every few minutes or so, also there is quite a bit of redundant information in the file.
 
Carl Trusiak
Sheriff
Posts: 3341
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This would better be answered in the XML forum. Take a look at what you can do with XSL and SQL.
------------------
Hope This Helps
Carl Trusiak
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!