Click here to Skip to main content
15,747,908 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am retrieving data from an Excel file and display it into datagrid.
Now, I want to store data from this datagrid into a SQL database.
How can I do this? Please help.

Thanks in advance.
Updated 31-Aug-10 0:35am

1 solution

By writing code, obviously. You can connect to Excel using ODBC, I believe. then you bind the data to your grid. You should store the data directly into a SQL database, just by writing a data layer that uses SQL to do that.
Share this answer
Dalek Dave 31-Aug-10 7:00am    
It can also be done directly from Excel.

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