Hi all,
Iam really in confusion. I have an excel workbook with 5 spreadsheets. In each of the spread sheets there r 1000's of records.All the spread sheets have common columns. I have to compare the different columns in the different spreadsheets with respect to the common columns for finding the difference between the 2 columns. By using the joins we can compare the data in two tables in SQL Server, but how i export the data from excel to SQL Server. I read in some articles that we can use SSIS package for that. I read some articles about SSIS, but that too confused me.So please help me to solve this issue.
Thanks in Advance
Sherin Samuel
Iam really in confusion. I have an excel workbook with 5 spreadsheets. In each of the spread sheets there r 1000's of records.All the spread sheets have common columns. I have to compare the different columns in the different spreadsheets with respect to the common columns for finding the difference between the 2 columns. By using the joins we can compare the data in two tables in SQL Server, but how i export the data from excel to SQL Server. I read in some articles that we can use SSIS package for that. I read some articles about SSIS, but that too confused me.So please help me to solve this issue.
Thanks in Advance
Sherin Samuel
Comment