Kash Posted April 23, 2009 Share Posted April 23, 2009 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 Link to comment Share on other sites More sharing options...
Moderators SmOke_N Posted April 23, 2009 Moderators Share Posted April 23, 2009 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!RegardsKashDon't double post! Common sense plays a role in the basics of understanding AutoIt... If you're lacking in that, do us all a favor, and step away from the computer. Link to comment Share on other sites More sharing options...
Recommended Posts