Jump to content
Sign in to follow this  
Kash

inserting data in MS Access using AutoIT program

Recommended Posts

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

Share this post


Link to post
Share on other sites
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!

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.

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  

×