Mass Import Data from Excel file to Access programmatically in C#

Question

Given the fact that Excel and Access are compatible in some level, is there a way to import data from an excel file to an Access Database programmatically, without reading the file and inserting data, record by record?

Fionnuala · Accepted Answer · 2013-02-08 15:13:51Z

5

Very roughly:

string ConnString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Z:\Docs\Test.accdb";
OleDbConnection conn = new OleDbConnection(ConnString);
conn.Open();
string sql = @"select * into newxl from [Excel 8.0;HDR=YES;DATABASE=Z:\Docs\Test.xlsx].[Sheet1$] s;";

OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();

answered Feb 8, 2013 at 15:13

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

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

Collectives™ on Stack Overflow

Mass Import Data from Excel file to Access programmatically in C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related