Question

Trying to Connect Excel from Control Room File

  • 12 April 2024
  • 1 reply
  • 33 views

Badge +3

Hi Developers,

 

Im trying to connect Excel as Database and the root path is from Control Room File with xlsx format. But Unfortunately its throwing error as below 
 

Could not Connect to Database. Error number: 80004005 'C:\Users\$Systemname\AppData\Local\Programs\Automation Anywhere\Bot Agent\Bots\DevelopmentBots\Customer Service POC.xlsx' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

 

Have anyone tried this before?

 


1 reply

Userlevel 4
Badge +6

Just to restate: You’re trying to connect Excel (running locally on your computer and/or bot runner) through the Microsoft database connector to a file uploaded to your Control Room? That is very, very unlikely to work. Using Excel as a database is already fragile, relying on OLE and ODBC together. I would either work with a local file, a file on a network share, or migrate that data to an actual database.

Even if you got that working, the likelihood that it would save any updated or inserted data back to the Excel file on the Control Room approaches zero.

Reply