Migrating data from XML file to Sybase tables

Hi,

I have data in XML format, I have to migrate all these data into Sybase table. XML structure is very simple.
IS there any way to directly upload these data from XML file to Sybase tables?

Thanks in advance.

Regards

Check out my post here on a Groovy way to go from XML to SQL inserts. All you need to do is download the Groovy package and use the 4 or 5 lines of code from my topic, slightly modified for your own use and you'll have an easy solution to parse and load data. Learn Groovy in the process. It's what I believe to be one of the strongest scripting languages available for Java.

*Edited 6/6/06 to fix broken link.
[ June 06, 2006: Message edited by: Clifton Craig ]

Hi Craig,

Thanks for your advice but I am unable to access Hyperlink 'my post' and where I can get this Groovy package..
Looking to hear from you ASAP.

Regards

Originally posted by arnav prateek:
Hi Craig,

Thanks for your advice but I am unable to access Hyperlink 'my post'

Here is the link http://codeforfun.wordpress.com/2006/06/05/groovy-xml-and-sql/

Thanks Balaji

My apologies for the broken link, and thanx Balaji for pointing him in the right direction. For what it's worth I fixed the broken link.