Skip to main content
Question

Excel as Database Connection issue

  • December 11, 2024
  • 4 replies
  • 63 views

Forum|alt.badge.img+1

Not able to connect to the database, there is some error for the connection string/ driver, my system has 64bit driver installed. Getting the below error.

 

4 replies

Forum|alt.badge.img+1
  • Author
  • Cadet | Tier 2
  • 4 replies
  • December 11, 2024

The connection string which i have used is this - Provider=Microsoft.ACE.OLEDB.12.0;Data Source=""C:\Users\Glen\Documents\AA360\Excel DB.xlsx"";Extended Properties="Excel 12.0 Xml;HDR=YES"


Forum|alt.badge.img+1
  • Author
  • Cadet | Tier 2
  • 4 replies
  • December 11, 2024

 


Forum|alt.badge.img+1
  • Author
  • Cadet | Tier 2
  • 4 replies
  • December 11, 2024
Glen Britto wrote:

The connection string which i have used is this - Provider=Microsoft.ACE.OLEDB.12.0;Data Source=""C:\Users\Glen\Documents\AA360\Excel DB.xlsx"";Extended Properties="Excel 12.0 Xml;HDR=YES"

the additional “” have been removed now im getting this error - 

 


Oli.Morris
Automation Anywhere Team
Forum|alt.badge.img+8
  • Automation Anywhere Team
  • 22 replies
  • December 11, 2024

Can you share a screenshot of your ODBC connections both 64-bit and 32-bit?

 

References:


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings