Insert data into Access 2007 from C#

[zuraberadze]

I can't connect C# to MS Access 2007 to insert data into DB. please help me. it can't see the type of db. thx

[ThatThatGuy]

Are you trying to connect to the newest form of access database that's

.accdb

[zuraberadze]

Are you trying to connect to the newest form of access database that's

.accdb

yes... and it can't see the db type.... with access 2003 no problem

[ThatThatGuy]

it seems that you're system is lacking the driver required to access [Access 2007] databases....
download it from here http://www.microsoft.com/downloads/d...displaylang=en

and then set the provider to

Provider=Microsoft.ACE.OLEDB.12.0;

in your connection string

[zuraberadze]

thanck u very much! and can u tell how can I connect C# to database graphically?

[ThatThatGuy]

thanck u very much! and can u tell how can I connect C# to database graphically?

You can drop a oledbConnection in the form and select a new DataSource...