Writing Records To Microsoft Access With Autoit (using Dao)

[Michael Lester]

Does anyone have an example (as simple as possible) showing how to use DAO to extract data and add data to a table in MS Access?

Thanks

Mike Lester

[Stumpii]

This may help: http://www.autoitscript.com/forum/index.ph...topic=20736&hl=

[billmez]

Does anyone have an example (as simple as possible) showing how to use DAO to extract data and add data to a table in MS Access?

Thanks

Mike Lester

Basic stuff in this post should be a good start:

http://www.autoitscript.com/forum/index.ph...topic=19597&hl=

_SelectData()

Func _SelectData($dbname = "C:\FullPathToDatabase.mdb", $tblname = "MyTable", $T = "*")
$addfld = ObjCreate("ADODB.Connection")
$addfld.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & $dbname)
$RS =ObjCreate("ADODB.Recordset")
$RS.ActiveConnection = $addfld
$RS.Open ("Select " & $T & " From " & $tblname )

msgbox(0,"", "Name: " & $RS.Fields(0).Name & " - Value: " & $RS.Fields(0).Value & @CRLF & "Name: " & $RS.Fields(1).Name & " - Value: " & $RS.Fields(1).Value & @CRLF & "Name: " & $RS.Fields(2).Name & " - Value: " & $RS.Fields(2).Value)

$RS.Close
$addfld.Close

EndFunc