compare excel column name with sql column name

Question

0.00/5 (No votes)

See more:

I have a SQL table with column name and no data. i have another excel sheet with column name and data. i need to import the data from excel to sql table. Before that i need to compare sql column names and excel column names. if thats ok then only it needs to be imported.

Please Help me with clear coding. code in c#

Posted 22-Jun-12 21:54pm

P.Vinoth

Add a Solution

Comments

ssd_coolguy 23-Jun-12 3:59am

hey.. let us know what you have tried?

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)

Espen Harlinn · Answer 1 · 2012-06-22T22:37:00

For access to the Excel spreadsheet you can use EPPlus[^]

SQL Server Management Objects [^] provides an easy to use API for accessing meta information, such as column names.

The Database.Tables[^] property provides access to the tables in the database, and the Table class has a Columns[^] property that you can use to access each Column[^] of the table in question.

You can then compare the Name[^] of the column against the column name from the Excel spreadsheet.

Best regards
Espen Harlinn

Hiren solanki · Answer 2 · 2012-06-22T22:10:00

Solution 1

You can either use SQL server Import export wizard which will ask you mapping the excel column to SQL. or use Integration service project[^] to begin with.

Posted 22-Jun-12 22:10pm

Hiren solanki

Comments

P.Vinoth 23-Jun-12 4:16am

Its good Hiren. But i need to do that by coding only. how to do that please help .