excel -sql server ?
-
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
AS you say, this is outside your experience because you know ASP.NET. So, it's not an ASP.NET task. Why did you then ask in the ASP.NET forum ?
Christian Graus Driven to the arms of OSX by Vista. "I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
-
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
How many times do you have to ask the same question? Stop Cross Posting NOW!
Yusuf Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
-
AS you say, this is outside your experience because you know ASP.NET. So, it's not an ASP.NET task. Why did you then ask in the ASP.NET forum ?
Christian Graus Driven to the arms of OSX by Vista. "I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
i said that coz i wanted to let ppl know that i am not a dba and don't know how to carry out such tasks... if anyone know how to get excel data in c# and transfer it to sql server database
haseeb
-
i said that coz i wanted to let ppl know that i am not a dba and don't know how to carry out such tasks... if anyone know how to get excel data in c# and transfer it to sql server database
haseeb
I know. It's just that, well, you're a moron. This is not the SQL forum. I pointed this out to you and your response to me left me wondering if you even read my reply.
Christian Graus Driven to the arms of OSX by Vista. "I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
-
I know. It's just that, well, you're a moron. This is not the SQL forum. I pointed this out to you and your response to me left me wondering if you even read my reply.
Christian Graus Driven to the arms of OSX by Vista. "I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
thanks , ur reply really helped... You know there are quite a few types of morons in this world. First there are morons like me who have very less idea and experience and post a msg on a site with 6073937 members, so that someone with a bit of idea could help. 2nd type of morons are those, who don't know the answer , still they reply... C'mon, this is world wide web, and there are 6073937 members... putting it more simply, if we subtract 2 (me moron and u moron) , still there are 6073835 members... and yeah, mostly there are programmers solving such problems, only big companies keep dba's... I am not saying that u are a moron , but wanna tell u that this type also exist Plz don't bother to reply again... Thanx for ur help..
haseeb
-
How many times do you have to ask the same question? Stop Cross Posting NOW!
Yusuf Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
i tried dts as was mentioned in ur link, but i was able to transform data from an excel file to only one database table,where as i want to transform it into multiple tables. Maybe dts can do it but i can't find any help on it... anyways, thanx for ur help and yeah, are u the only guy responsible for answering queries of the whole world? why don't u leave my query and give others a chance to provide help... anyways... thanx alot... Please , consider not answering back if u are gonna write something like "STOP cross-posting"... coz i think i know that u are smart bye, thanx
haseeb
-
i tried dts as was mentioned in ur link, but i was able to transform data from an excel file to only one database table,where as i want to transform it into multiple tables. Maybe dts can do it but i can't find any help on it... anyways, thanx for ur help and yeah, are u the only guy responsible for answering queries of the whole world? why don't u leave my query and give others a chance to provide help... anyways... thanx alot... Please , consider not answering back if u are gonna write something like "STOP cross-posting"... coz i think i know that u are smart bye, thanx
haseeb
Look, There is no obligation on our end to help you. We do it because we like helping people, but we don't do your work for you. If you want to receive assistance, first and foremost, you need to get your act together and watch your behavior. We have seen many who went down the hill very quickly. And you will find that very quickly if you don't change your attitude.
Yusuf Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
-
i tried dts as was mentioned in ur link, but i was able to transform data from an excel file to only one database table,where as i want to transform it into multiple tables. Maybe dts can do it but i can't find any help on it... anyways, thanx for ur help and yeah, are u the only guy responsible for answering queries of the whole world? why don't u leave my query and give others a chance to provide help... anyways... thanx alot... Please , consider not answering back if u are gonna write something like "STOP cross-posting"... coz i think i know that u are smart bye, thanx
haseeb
just stop cross posting, OK ?
Christian Graus Driven to the arms of OSX by Vista. "I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )