Results 1 to 2 of 2
  1. #1

    Not able to connnect to 64bit Excel 2010 database

    Hi Friends

    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

  2. #2
    Advanced Member
    Join Date
    May 2006
    United Kingdom
    Is driver issue?
    Also information about ACE driver.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
BetaSoft Inc.
All times are GMT -8. The time now is 06:00 PM.

Copyright BetaSoft Inc.