Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Blank Data Files after windows/excel update - OLEDB Open() issues
I've upgraded from Windows 10 to Windows 11, and Excel 2019 to Excel 365 (x64)
Some files under C:\PortfolioSlicer\PSData such as Symbol.csv are only showing the header when I update...
When I run UpdatePSData I get following issues:
Symbol '* Cash' in Quotes.csv but not in Symbol.csv
Symbol 'BBEP' in Quotes.csv but not in Symbol.csv
Symbol 'CLNY' in Quotes.csv but not in Symbol.csv
Symbol 'GA' in Quotes.csv but not in Symbol.csv
Symbol 'OVTI' in Quotes.csv but not in Symbol.csv
...
Troubleshooting further, running only GetExcelSrcData.ps1
I see the following error/issue:
Provider open failed with error: Exception calling "Open" with "0" argument(s): "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."
I cannot figure out how to get this fixed up past this point! Please I would appreciate the help!
Some files under C:\PortfolioSlicer\PSData such as Symbol.csv are only showing the header when I update...
When I run UpdatePSData I get following issues:
Symbol '* Cash' in Quotes.csv but not in Symbol.csv
Symbol 'BBEP' in Quotes.csv but not in Symbol.csv
Symbol 'CLNY' in Quotes.csv but not in Symbol.csv
Symbol 'GA' in Quotes.csv but not in Symbol.csv
Symbol 'OVTI' in Quotes.csv but not in Symbol.csv
...
Troubleshooting further, running only GetExcelSrcData.ps1
I see the following error/issue:
Provider open failed with error: Exception calling "Open" with "0" argument(s): "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."
I cannot figure out how to get this fixed up past this point! Please I would appreciate the help!
Comments
On your machine you need to install drivers that allow to read Excel data from PowerShell scripts. These are drivers for 'Microsoft.ACE.OLEDB.12.0', most likely your machine is 64bit, but you need to check this.
Here is the link that talks about installing these drivers and provides direct download links:
https://learn.microsoft.com/en-us/answers/questions/1658052/download-link-for-microsoft-ace-oledb-12-0