excel ado.net sql problem
-
I have an excel file and want to copy data to sql server. The excel file has a field name: device name , and a field named: model...(there are 30 more fields) deviceName model laptop acer 1640 laptop fujitsu laptop sony notebook ibm laptop ibm. I need to transfer these files into the sql server database. i know that i require 2 tables in sql with one table for devices and another for models and both should have a relationship of M:N. hence another table is required. My question is that is there any easy way of doin this in sql server or do i have to program it... I have searched regarding dts and it seems that dts works well when only one table has to be transtered to one table. there is a possibility that dts does it but i don't know how to develop scripts in dts as i am an asp.net developer. Do i have to find a way out using C# or are there any tools that solve such problems any help will highly appreciated. thanx
haseeb
-
I have an excel file and want to copy data to sql server. The excel file has a field name: device name , and a field named: model...(there are 30 more fields) deviceName model laptop acer 1640 laptop fujitsu laptop sony notebook ibm laptop ibm. I need to transfer these files into the sql server database. i know that i require 2 tables in sql with one table for devices and another for models and both should have a relationship of M:N. hence another table is required. My question is that is there any easy way of doin this in sql server or do i have to program it... I have searched regarding dts and it seems that dts works well when only one table has to be transtered to one table. there is a possibility that dts does it but i don't know how to develop scripts in dts as i am an asp.net developer. Do i have to find a way out using C# or are there any tools that solve such problems any help will highly appreciated. thanx
haseeb
Suddenly there are a heck of a lot of posts about this. Is this the latest coursework assignment?
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”
-
Suddenly there are a heck of a lot of posts about this. Is this the latest coursework assignment?
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”
Unless it's an international course they're doing.....no :-D but still there's a heck of a lot of them :omg: