To copy the data in Excel file,XML file into a database?

[saurabh9gupta]

Hello.
I have two files . One is Excel file and the other is XML file. I need to copy the data present in them into the SQL Server Database.

Any idea on how to proceed on this?

[ck9663]

If this is just one time, just use the Import Wizard. If not, try this and this...

Good Luck!!!

~~ CK

[saurabh9gupta]

i have tried this and this (links).
I want some C# code to do the job!

[ck9663]

Then try posting it in C# forum. This is more of C# question, than a SQL Server question.

Good Luck!!!

~~ CK