USING EXCEL TO GET DATA FROM WEB PROBLEM
 

TRYING TO ENTER DATA INTO EXCEL USING THE "GET DATA FROM WEB" FUNCTION.
AFTER ENTERING THE URL ADDRESS i GET AN ERROR FUNCTION.

I HAVE USED BOTH TWINSPIRES AND NYRA BETS WPS POOL TABLES.
CAN USE SOME HELP HERE TO CORRECT THE ERROR.

THANKS

What is the error?

here it is

LOL

That was helpful.

Are you using a relatively new version of Excel?

I'm of the opinion that what's happening is that your request for the page is being rejected because they don't want "your browser" (whatever Excel reports as) to scrape.

MICROSOFT 365 FAMILY SUBSCRIPTION

TRIED DIFFERENT BROWERS. STILL NOT WORKING.
DO YOU HAVE SUCCESSFUL USE OF THIS EXCEL FEATURE?

IMPORTANT THINGS TO NOTE WHEN IMPORTING DATA FROM THE WEB INTO MICROSOFT EXCEL
You need to meet two requirements to import data from the web into Microsoft Excel:

Microsoft Excel version: Power Query supports importing data. With Power Query, Excel users can connect, transform, combine and load data. However, Power Query is only available on Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, and Excel 2010.

Data Format: when importing data from the web into Microsoft Excel, the data must be in tabular form or embedded within an HTML table. If the data is not in a table, then Power Query won’t identify it.

No.
I write code.
While me writing an export to Excel has great value, forcing my users to have Excel does not.

Sorry.

This is like the 1 to 9 explanation.

LOL

Agree, but that's all I've got.

i thought this might explain the problem.

"IMPORTANT THINGS TO NOTE WHEN IMPORTING DATA FROM THE WEB INTO MICROSOFT EXCEL
You need to meet two requirements to import data from the web into Microsoft Excel:

Microsoft Excel version: Power Query supports importing data. With Power Query, Excel users can connect, transform, combine and load data. However, Power Query is only available on Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, and Excel 2010.

Data Format: when importing data from the web into Microsoft Excel, the data must be in tabular form or embedded within an HTML table. If the data is not in a table, then Power Query won’t identify it."

if you are successfully transferring the web page to excel, I could use your help

as do I

Formula,

Use amwager. They have a "copy data" button that gives you the information without a fancy new Excel feature. Copies to clipboard.

SK

I've had problems with Excel's 'new fangled import wizard, fortunately you can still access the the legacy wizard but it is hidden in the options, you need to enable it. (Show legacy data import wizards)

https://support.microsoft.com/en-us/...9-bc4a11bcc2a2

thanks but clipboard (sutting and pasting) is what i have been doing. i need automatic updates'
i signed up with at the races pro yesterday. awaiting access to same. this may give me what i need..

see attached. it has always been checked off.
are you successfully appending excel with any adw's tote board data?