how to insert values from c# application into excel using Odbc

Question

i have extracted the names from database and displayed them on web page.Now I wish to insert those names into excel sheet.how can i do that? please help

Andrew Schuster · Accepted Answer · 2014-06-04 15:18:55Z

2

This works fine.

string connectionString = "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=D:\\ConsoleApp\\Books1.xls; FIRSTROWHASNAMES=0;READONLY=FALSE;";

DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.Odbc");           
using (DbConnection connection = factory.CreateConnection())
{
    connection.ConnectionString = connectionString;

    using (DbCommand command = connection.CreateCommand())
    {
        command.CommandText = "INSERT INTO [Sheet1$](id,name) VALUES('2', 'test')";

        connection.Open();
        command.ExecuteNonQuery();
    }

}

edited Jun 4, 2014 at 15:18

Andrew Schuster

3,2292 gold badges24 silver badges32 bronze badges

answered Jun 4, 2014 at 13:00

user2331656

212 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Perk Over a year ago

what is [Sheet1$] and Dbq mean?

Collectives™ on Stack Overflow

how to insert values from c# application into excel using Odbc

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related