Excel Data to Sql Database
-
Hello Experts!! I am creating 2 datasets after retreiving infromation from excel sheet, now i want to store these datasets in a sql database. any ideas how to get this done? Thanks in Advance!!
-
Hello Experts!! I am creating 2 datasets after retreiving infromation from excel sheet, now i want to store these datasets in a sql database. any ideas how to get this done? Thanks in Advance!!
-
Anything you tried??
"If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'." - Dave Barry
I tried sqlbulkcopy and doesnt look good for me...
-
Hello Experts!! I am creating 2 datasets after retreiving infromation from excel sheet, now i want to store these datasets in a sql database. any ideas how to get this done? Thanks in Advance!!
-
Perhaps SqlDataAdapter Class[^] Mika
I will try this in the morning tomorrow and let you know, can you type in 2 lines of code showing it with SqlDataAdapter? I am not sure of the properties of it. Thanks Mika!
-
I will try this in the morning tomorrow and let you know, can you type in 2 lines of code showing it with SqlDataAdapter? I am not sure of the properties of it. Thanks Mika!