473,432 Members | 1,812 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > microsoft sql server > questions > how to compare two spread sheets in an excel sheet using sql server?

Join Bytes to post your question to a community of 473,432 software developers and data experts.

How to compare two spread sheets in an excel sheet using SQL Server?

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
Jul 2 '10 #1
1 4828
ck9663
2,878 Expert 2GB
You can use import the excel into two tables and compare the tables accordingly.

Good Luck!!!

~~ CK
Jul 7 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
Searching multiple excel sheet using a vb.net app
by: Scott | last post by:
I want to search 5 or 6 very big excel spreadsheets looking for specific data held in them. The search would be using clients surnames and maybe postcodes to eventually find the correct person. ...
Visual Basic .NET
4
How to delete first row from an Excel Sheet using C#.Net
by: B.N.Prabhu | last post by:
How to delete first row from an Excel Sheet using C#.Net. Please Help. Its very urgent.
C# / C Sharp
5
How to export data from webpage to excel sheet using javascript
by: Rishika14 | last post by:
Hi, Somebody pls tell me how to export data from webpage to excel sheet using java script. rishika
Javascript
1
opening a new excel sheet using VB
by: gowthamkumar | last post by:
HII ... please give me a code to open a new excel sheet using VB so that i can also directly add some contents in the cells of the excel sheet in VB itself .. i ve use the existing excel sheet code...
Visual Basic 4 / 5 / 6
4
can we send data from html to excel sheet using java script
by: sandeep123456 | last post by:
hi, can we send data from html to excel sheet using java script sandeep
Javascript
2
importing datagridview datas to excel sheet using c#.net(win forms)
by: abiramii | last post by:
Hi How to Import datagridview datas to excel sheet using c#.net(win forms)
.NET Framework
3
can we disable copy and paste functionality for excel sheet using javascript?
by: dileepkms | last post by:
can we disable copy and paste functionality for excel sheet using javascript? if we do it, can you send me the code
Javascript
2
read the excel sheet using javascript?
by: sanjuindia2005 | last post by:
How can i read the excel sheet using javascript ?
Javascript
4
To create an Excel Sheet using ASP.NET 2.0 with C#
by: =?Utf-8?B?Sm9zaW4gSm9obg==?= | last post by:
I could create MS Excel sheet using ASP.NET 2.0 with C# but it is not being created in some systems, following error occurs when the program compiles : Microsoft Office Excel cannot open or...
ASP.NET
1
code for getting maximum rows in excel sheet using perl script
by: sree ram | last post by:
code for getting maximum rows in excel sheet using perl script
Perl
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
1
Is that possible of reading the .csv file in column wise and the column have different lengths ?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
C / C++
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
jinu1996
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
Online Marketing
0
tracyyun
Discussion: How does Zigbee compare with other wireless protocols in smart home applications?
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
General
0
agi2029
AI Job Threat for Devs
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
Career Advice
0
isladogs
Access Europe - Using VBA to create a class based on a table - Wed 1 May
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
Microsoft Access / VBA
0
Couldn’t get equations in html when convert word .docx file to html file in C#.
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
C# / C Sharp
0
Windows Forms - .Net 8.0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
Visual Basic .NET

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!