how can i insert data into MS Access from Sqlserver 2008 database table in C#

Question

I am using this query for insert data into MS Access from Sql server 2008 database using C#

 INSERT INTO
 Table1([sno],[DataOfCreation],[Time],[IdentityType],[Description],[SpenderName],[Amount],[VoucherNo],[Session],[Mid],[Type])select
 [sno],[DataOfCreation],[Time],[IdentityType],[Description],[SpenderName],[Amount],[VoucherNo],[Session],[Mid],[Type]
 from
 [OLEDB;Provider=SQLNCLI10;Server=CMACHINE-PC\\SQLEXPRESS;Database=Voucher;].Voucher_Details";

But I found an Error :

"Could not found installable ISAM" .

Can Anyone help me to solve this problem

you can also check this video. youtube.com/watch?v=EUDQT4zdXE0 — Raghubar
– Raghubar, Commented Jul 25, 2013 at 5:26

C Sharper · Accepted Answer · 2013-07-25 05:42:18Z

1

ISAM drivers are used by Access to update file formats other than its own. If the path of the ISAM driver in your Windows Registry is not valid, or if the ISAM driver does not exist, the problem may occur.

This error will also be generated when the syntax of the connection string is incorrect. This commonly occurs when using multiple Extended Properties parameters. Below is an example:

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\DB.mdb;Extended Properties=""Access 8.0;HDR=NO;IMEX=1"""

See your datasource is quoted or not. This must be a problem in connection string.

answered Jul 25, 2013 at 5:42

C Sharper

8,66430 gold badges96 silver badges158 bronze badges

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

5 Comments

Swati Over a year ago

I want to data from sqlserver 2008 tables for insert data into mS Access so please help me for connection string SqlServer 2008 database using C#

C Sharper Over a year ago

@Swati you can fill in values for connection string as i have mentioned in my answer

Swati Over a year ago

Hello sir you send me connection string for MS Access but I want for Sql Server

C Sharper Over a year ago

Server=.\MSSQLSERVER2008;Database=DBNAME;integrated security=true

Swati Over a year ago

thanks for give me resonse I am using "[OLEDB;Provider=SQLNCLI10;Server=CMACHINE-PC\\SQLEXPRESS;Database=Voucher;integrated security = true;" but again I found same error "Could not installable ISAM"

Collectives™ on Stack Overflow

how can i insert data into MS Access from Sqlserver 2008 database table in C#

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related