Click here to Skip to main content
15,876,991 members
Please Sign up or sign in to vote.
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.

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.
Share this answer
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.
Share this answer
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.

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900