I have some doubt please help me.

How EXEL data goes into database.

Means I have to write a program (Windows application) How EXEL data goes into database.

Case 1 I have a database which has a table ‘DEMAND�/span>

Case 2 and I have to opened the same table ‘DEMAND�into excel which has all the column name as in database table ‘DEMAND�/span>

Case 3 exemple: I have opened the same database table into excel

Case 4 on click of Demand data should be goes into Database table. We have to consider data type also.

Hi pawan lodwal,

What do you mean by “How EXEL data goes into database� Did you mean importing data to database from Excel? If so, as far as I know, there are two possible ways to import data to database from Excel.

The first one is to read Excel using OLEDB, ant then using ADO.NET to write the data to database. Here are some samples for your reference.

· http://www.codeproject.com/KB/office/excel_using_oledb.aspx

· http://www.codeproject.com/KB/database/excel_odbc.aspx

· http://www.codeproject.com/KB/database/DBManipulationADONET.aspx

The second way is to use the SQL script to import data to database from Excel. Here is a sample for you reference.

· http://www.codeproject.com/KB/reporting-services/ImportDataUsingTSQLScript.aspx

Hope this helps.
Best regards.
Rong-Chun Zhang

Hi pawan lodwal,

What do you mean by “How EXEL data goes into database� Did you mean importing data to database from Excel? If so, as far as I know, there are two possible ways to import data to database from Excel.

The first one is to read Excel using OLEDB, ant then using ADO.NET to write the data to database. Here are some samples for your reference.

· http://www.codeproject.com/KB/office/excel_using_oledb.aspx

· http://www.codeproject.com/KB/database/excel_odbc.aspx

· http://www.codeproject.com/KB/database/DBManipulationADONET.aspx

The second way is to use the SQL script to import data to database from Excel. Here is a sample for you reference.

· http://www.codeproject.com/KB/reporting-services/ImportDataUsingTSQLScript.aspx

Hope this helps.
Best regards.
Rong-Chun Zhang