Click here to Skip to main content
14,668,908 members
Rate this:
Please Sign up or sign in to vote.
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

Rate this:
Please Sign up or sign in to vote.

Solution 1

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.
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, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100