Excel to Sql server 2005
-
I have huge excel files with columns havng redundant data. I want to transfer all the excel data into a sql database which is properly fragmented that is 2 tables are used to get the one to many relationship working... Is there any easy way of doin it... Can anybody provide help regarding SSIS and Dts. i am unable to find Business Intelligence studio .. I don't think i have it... Please provide help and links to help sites Thanx
haseeb
-
I have huge excel files with columns havng redundant data. I want to transfer all the excel data into a sql database which is properly fragmented that is 2 tables are used to get the one to many relationship working... Is there any easy way of doin it... Can anybody provide help regarding SSIS and Dts. i am unable to find Business Intelligence studio .. I don't think i have it... Please provide help and links to help sites Thanx
haseeb
Do you have programming experience ? You could write a VB.NET application that would open the Excel document, loop through the rows and create INSERT statements to your SQL server.
-
I have huge excel files with columns havng redundant data. I want to transfer all the excel data into a sql database which is properly fragmented that is 2 tables are used to get the one to many relationship working... Is there any easy way of doin it... Can anybody provide help regarding SSIS and Dts. i am unable to find Business Intelligence studio .. I don't think i have it... Please provide help and links to help sites Thanx
haseeb
-
Is there any way to map to multiple tables...do i have to create the database for it manually and then use dts or all tables will be created automatically. also my excel file well there are 2 of them lead to about 10 sql tables of data... how would i be able to fill up these tables with data from excel file which is more than 15mb. how do i get ssis on my system thanx
haseeb
-
Is there any way to map to multiple tables...do i have to create the database for it manually and then use dts or all tables will be created automatically. also my excel file well there are 2 of them lead to about 10 sql tables of data... how would i be able to fill up these tables with data from excel file which is more than 15mb. how do i get ssis on my system thanx
haseeb
there is only one way to find out. Make a copy of your excel file and try it out. you want learn unless you try it.
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[^]