libin Posted January 12, 2015 Share Posted January 12, 2015 (edited) Good Day! I was trying to connect to excel OLEDB with the below code snippet and when i execute the script i get an error "provider cannot be found.It may not be properly installed".However when i connect to excel DB with the same connection string using vb script,it works without any issue. My Autoit code - Local $str12ConnectionString,$objDBConnect,$objRecordSet Local $strsqlquery,$objpropdict,$strLoggermessage ; Initialize COM error handler $oMyError = ObjEvent("AutoIt.Error","fn_get_err_data") Local $strorfilepath="C:UsersR609DesktopAutoITRootTestDataObjectIdentifier.xlsx" Local $str12Provider = "Microsoft.ace.OLEDB.12.0" $str12ConnectionString = "Data Source=" & $strorfilepath & ";Extended Properties=Excel 12.0;" $objDBConnect = ObjCreate("ADODB.Connection") $objDBConnect.Open ("Provider=" & $str12Provider & ";" & _ "Data Source="& $strorfilepath &";" & _ "Extended Properties=Excel 12.0") My vb script code - strorfilepath = "C:UsersR609DesktopAutoITRootTestDataObjectIdentifier.xlsx" str12Provider = "Microsoft.ace.OLEDB.12.0" Set objDBConnect = CreateObject("ADODB.Connection") objDBConnect.Open ("Provider=" & str12Provider & ";" & _ "Data Source=" & strorfilepath & ";" & _ "Extended Properties=Excel 12.0") Can some one help me to resolve the issue? Thanks in advance Libin S Edited January 12, 2015 by libin Link to comment Share on other sites More sharing options...
water Posted January 12, 2015 Share Posted January 12, 2015 Welcome to AutoIt and the forum! Maybe the wiki tutorial (including examples how to access Excel) will solve your problem. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
riyanmarge Posted November 3, 2016 Share Posted November 3, 2016 Hope this will help you...Excel OLEDB example Riyan Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now