How to export Excel or Text file to Sql table

Question

0.00/5 (No votes)

See more:

How to dynamically export Excel or Text file to Sql table, means select the file(Excel or text) and select the sql table also, and drag excel file column to sql table column and export the data to selected columns.

Posted 12-Jul-11 21:57pm

Robymon

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)

walterhevedeich · Answer 1 · 2011-07-12T22:10:00

You basically need to do the following. I provided some links that may help you get started.

1. Open Excel file using OLEDB[^] then put it in a control, such as a datagrid.
2. Get the list of tables from your database[^] and display them on your app, then put it in a control that will allow you to select the tables/columns.

Robymon · Answer 2 · 2011-07-12T22:26:00

Solution 2

How to drag or match excel column to sql table column? which control i can use?
while selecting the excel or text file i just want to see the column names only in the left side and in the right side i want to see the sql table columns and i want to drag the columns Like DTS [ data transformation service ] and export the selected columns.

Posted 12-Jul-11 22:26pm

Robymon

Comments

BobJanova 13-Jul-11 6:03am

To discuss a solution, you should use 'Add Comment' under the solution. To update your question, use 'Improve Question'. You shouldn't post solutions if you are trying to discuss something already posted.