UpdatePSDataFromExcel Won't Run Successfully When Trying to Migrate to v3.x

mg3putt

Vidas, I am having great difficulty getting my v2.4 migrated to v3 working properly. I have followed the instructions from here (http://www.portfolioslicer.com/version3notes.html). I am running Win 11 for ARM (which I have been doing for years with Portfolio Slicer)

I get the following error which I thought indicates that I need to download the Access driver which I have done (see below)


I am using Excel 2016 which is 64-bit


I installed the 64bit version of the Access Database Engine from here https://web.archive.org/web/20230924130050/https://www.microsoft.com/en-us/download/details.aspx?id=13255 (the link in the instructions)

This shows that it is installed (although it doesn’t explicitly state it is 64 bit)


I have also checked out this thread without any success ( http://support.portfolioslicer.com/index.php?p=/discussion/684/upgrading-to-v3-1-0 )

Any tips would be appreciated. Thank you. Mark

VidasMatelis

Can you please try solution posted in the last message of this thread:

https://support.portfolioslicer.com/index.php?p=/discussion/738/script-error#latest

mg3putt

Thank you Vidas, the solution worked. The script completed without any errors.

I now have new problems but I will work on these ones in the next few days.

Mark