Forum Discussion
accessing a file embedded on a web page
- 6 years ago
Thank you for all your help!
1. Do Get Data
2. Choose the Web option
3. Type in the url
4. Choose anonymous authentication.
5. Hit load
Or add a new blank query and type inb:
= Excel.Workbook(Web.Contents("https://www.eia.gov/dnav/pet/xls/PET_PRI_SPT_S1_D.xls"), null, true)
- wrwillits6 years ago
Helper III
Hi Artemus,
I have tried both of your options but keep getting the error that states that I need a 64 bit version of "Access Database Engine 2010 Access Database Engine OLEDB" to read this file. I'm running a 64 bit version of Office 365 Access already. Also, I tried to download a version of "Access Database Engine 2010" thinking that maybe I had a older version, but the system told me that I'm running a "32 bit Office Product and need to upgrade to a 64 bit version". I double checked my Office suite and confirmed that I'm running a 64 bit version.
What's going on?