Thanks again. I got it all working as you suggested. Thansk for quick repaly. That was very helpful.

Thanks again for your time.

Hi Hall Of Fame, again me. Sorry to bother you again, can you help with the last XML file to import it into SQL table.

Here is the file:

--------------------------------------

<?xml version="1.0" encoding="utf-8"?>

<DataSet...

Hall of Fame,

Thanks for your help. It is working with XQUERY and that is fantastic. You saved me probably a week and more work on this XML import.

Thanks again.

I was hoping tu use OPENXML and T-SQL. It will ebnice to create the whole impor tprocess as a stored procedure. Hmmm. Anyone can help with OPENXML?

Thanks for reply. It will be an ongoing process (XML data will be process daily). I'll check the link.

Thanks