inserting data in MS Access using AutoIT program

[Kash]

Hello,

Can someone provide code snippet for inserting data in MS Access Database using AutoIT program?

I am using below code butit is not working.

$dbname="TestAccessDB.mdb"

$addfld = ObjCreate("ADODB.Connection")

$addfld.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & $dbname)

$sql_insert = "insert into CallRecords(BAN,Timestamp) values('1234','04/22/2009') "

$addfld.Execute($sql_insert)

$addfld.Close

Thank you!

Regards

Kash

[SmOke_N]

Hello,

Can someone provide code snippet for inserting data in MS Access Database using AutoIT program?

I am using below code butit is not working.

$dbname="TestAccessDB.mdb"

$addfld = ObjCreate("ADODB.Connection")

$addfld.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & $dbname)

$sql_insert = "insert into CallRecords(BAN,Timestamp) values('1234','04/22/2009') "

$addfld.Execute($sql_insert)

$addfld.Close

Thank you!

Regards

Kash

Don't double post!