Not able to connnect to 64bit Excel 2010 database
I am using Excel 2010 64bit, Windows 7, QTP 11.0
I am not able to connect to excel using below code... (Code was working fine with Excel 2007 in Windows7)
strInputExcelFile = "C:\Automation\AM_Test_Data.xlsx"
'On Error Resume Next
Set oConn= CreateObject("ADODB.Connection")
oConn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&strInputExcelFile&";Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1"";"
getting "Provider cannot be found. It may not be properly installed." message when i execute the abobe code.
When googled found out that its a issue with 64bit excel, but didn't get any solution
Can anyone please help me in resolving this issue..
also let me know if we have to use any connectionstring for 64bit excel
Thank you in advance