from excel --> XML --> SQL db

[divinyl]

Hi all,

I need to extract a whole bunch of data out of excel into XML and then into a SQL database (that already exists). This particular job will be a one off, but i think a request like this will probably come again in the future, so I want to write a little app that i can use later. I was thinking perhaps something in .NET (simply cause i have a little skill in this area) though i wouldn;t know where to start. I am pretty much a beginner, so any advice/tips/pointers to the right info would be very much appreciated.

Thanks

Divinyl

 

[harebrain]

Would that be a SQL Server database? (Specifics, please.) If so, skip the XML and create a DTS package: done.

 

[celeron895]

Agreed. No reason to use XML here (if you are talking SQL Server). DTS is the way to go!!!!!!!!

 

[divinyl]

Guys,

Thanks for this - i was worried that because of the relationships between tables (i will be importing from/into multiple tables, and YES - it is SQL) that DTS would fail on the primary/foreign key links...i am not the dba and the db structure is quite complex (corporate risk assessment - ugh!) but if it means cutting out the middle man (XML) i'll be glad to give it a go...

I will let you know how i get on!

Thanks

Neile