Open ( "Provider=.4.0 Data Source=" & $dbname ) Use this line if using MS Access 2007 and using the. Local $title Local $dbname = "D:\Documents\1_Daniel\Access\Import_Fill_Empty.accdb" Local $tblname = "newfile" Local $query = "SELECT * FROM " & $tblname & " WHERE ID = 10" Local $oShell = ObjCreate ( "shell.application" ) Get the Windows Shell Object ConsoleWrite ( "oShell=" & $oShell & ) $adoCon = ObjCreate ( "ADODB.Connection" ) ConsoleWrite ( "adocon=" & $adoCon & ) $adoCon.Open("Driver= DBQ=" & $dbname) Use this line if using MS Access 2003 and lower $adoCon. I the end need to read table data to an array So I made an file DSN as suggested in the script, but I don't know how to get this working.īelow is another piece of code I came up with. Yesterday I found a piece of code from GreenCan LINK TO TOPIC which seems promising. ![]() ![]() I tried several UDF's from the Forum without any luck. Hi, I'm trying to connect to an Access database (2016) for some time now.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |