how to validate excel sheet

Question

4.00/5 (1 vote)

See more:

i have excel sheet there are list of countries. i want to add country data in sql server but at the time of storing data it check validation like country is already exist in database or not? then store into db.

Posted 29-Oct-12 21:40pm

Member 9027346

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

satz_770 · Answer 1 · 2012-10-30T00:54:00

It is not that difficult.. easy one...
1.go to "SQL Server Management studio"
2.Right click on ur database name and select "Tasks -> Import Data"
3.Now select "Microsoft Excel" as DataSource
4.In Excel file path browse and give ur excel file(input)
5.Select appropriate excel version and give "Next"
6.Now select Destination as "SQL Server Native Client 10.0"
7.Select appropriate Sever name, DB name, Authentication and give "Next".
8.Now select "Write a query to specify the data to Transfer"
9.Now give ur query
10.give 3 times "Next" and then "Finish"

Now u have successfully inserted data to a new table created. If u want to add data to already existing table, after step 9 i.e. after giving ur query, select destination from the destination column displayed in the next step. Usually it shows a new table name but u can select already existing tables from the drop down list....

For any clarifications reply to this,
Mark it if u find it useful.

I.explore.code · Answer 2 · 2012-10-30T00:05:00

A similar question that I answered not very long ago: How to import excel data to SQL database table[^]

Once you understand how to do this, you can easily validate the data before saving as well. You just have to loop through the collection and see if that country exists in the db or not. And the way you check whether it exists in db or not, is to do a select query for that name and see if any results are returned (pretty basic really).

how to validate excel sheet

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0