Skip to main content
Question

Excel as database issue

  • December 7, 2024
  • 7 replies
  • 199 views
P
Forum|alt.badge.img+1

Hi All,

I have installed Microsoft access database engine 2016 (64 bit) and I have Excel 2019 version. Still facing connection issue like. ‘Could not Connect to Database. Error number: 80004005 Failure creating file.’ If I uncheck the ‘Use ODBC 64-bit driver for connection’ then error is changing to this - ‘Could not Connect to Database. Provider cannot be found. It may not be properly installed.’

 ​@Automation Anywhere Team Please suggest some solution and let me know if any other details required from my end.

Configurations
Database engine version 

Thanks,

Tamal

Vatsy
Ganesh Bhat

7 replies

Oli.Morris
Automation Anywhere Team
Forum|alt.badge.img+12
  • Oli.Morris
  • Automation Anywhere Team
  • December 9, 2024

Have you verified that it’s been installed correctly? If you type `ODBC` into the start menu and open up the ODBC Data Sources (check both 32-bit and 64-bit) you should see:

Also worth referring back to the awesome QuickTip.

P
Forum|alt.badge.img+1
  • Papa 5365
  • Author
  • Cadet | Tier 2
  • December 9, 2024

Hi ​@OliverM108256 

Thanks for your quick response.

I have checked those drivers in my system, 32 bit one is not present but 64 bit one is there. Should I need both?

Please suggest.

 

Thanks,

Tamal

Oli.Morris
Automation Anywhere Team
Forum|alt.badge.img+12
  • Oli.Morris
  • Automation Anywhere Team
  • December 10, 2024

That’s great you just need one installed but make sure you untick the 64-bit driver checkbox in the image you shared.

P
Forum|alt.badge.img+3
  • Prakash 355
  • Navigator | Tier 3
  • July 31, 2025

Hi ​@Oli.Morris ,
I did the same and connection strig  also correct but not able to conect excel as database.

Please suggest what procedure should i follow.

Thanks,
Prakash Malshetti

Padmakumar
Premier Pathfinder | Tier 7
Forum|alt.badge.img+15
  • Padmakumar
  • Premier Pathfinder | Tier 7
  • July 31, 2025

Hi ​@Oli.Morris ,
I did the same and connection strig  also correct but not able to conect excel as database.

Please suggest what procedure should i follow.

Thanks,
Prakash Malshetti

 

What error are you getting? 

 

Padmakumar
P
Forum|alt.badge.img+3
  • Prakash 355
  • Navigator | Tier 3
  • July 31, 2025

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=”C:\Users\PRAKASH\Downloads\US+Individuals+Data+-+56000+records.xlsx”;Extended Properties="Excel 12.0 Xml;HDR=YES"

Excel file format: xlsx

Padmakumar
Premier Pathfinder | Tier 7
Forum|alt.badge.img+15
  • Padmakumar
  • Premier Pathfinder | Tier 7
  • July 31, 2025

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=”C:\Users\PRAKASH\Downloads\US+Individuals+Data+-+56000+records.xlsx”;Extended Properties="Excel 12.0 Xml;HDR=YES"

Excel file format: xlsx

 

I can see from the screenshot that you have mentioned something different than the below connection string. Especially the version.

 

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=”C:\Users\PRAKASH\Downloads\US+Individuals+Data+-+56000+records.xlsx”;Extended Properties="Excel 12.0 Xml;HDR=YES"

Padmakumar
Terms & ConditionsCookie settingsAccessibility statement