 |
|
05-19-2022, 12:58 PM
|
#1
|
|
what an easy game.
Join Date: Dec 2002
Posts: 43,096
|
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
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
" I pass with relief from the tossing sea of cause and theory to the firm ground of result and fact"
Winston Churchill
|
|
|
|
05-19-2022, 01:08 PM
|
#2
|
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,900
|
What is the error?
|
|
|
|
|
05-19-2022, 06:48 PM
|
#3
|
|
what an easy game.
Join Date: Dec 2002
Posts: 43,096
|
Quote:
Originally Posted by Dave Schwartz
What is the error?
|
here it is
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
" I pass with relief from the tossing sea of cause and theory to the firm ground of result and fact"
Winston Churchill
|
|
|
|
|
05-19-2022, 07:20 PM
|
#4
|
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,900
|
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.
|
|
|
|
|
05-19-2022, 08:36 PM
|
#5
|
|
what an easy game.
Join Date: Dec 2002
Posts: 43,096
|
Quote:
Originally Posted by Dave Schwartz
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?
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
" I pass with relief from the tossing sea of cause and theory to the firm ground of result and fact"
Winston Churchill
|
|
|
|
|
05-19-2022, 09:53 PM
|
#6
|
|
what an easy game.
Join Date: Dec 2002
Posts: 43,096
|
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.
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
" I pass with relief from the tossing sea of cause and theory to the firm ground of result and fact"
Winston Churchill
|
|
|
|
|
05-19-2022, 10:02 PM
|
#7
|
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,900
|
Quote:
Originally Posted by formula_2002
MICROSOFT 365 FAMILY SUBSCRIPTION
TRIED DIFFERENT BROWERS. STILL NOT WORKING.
DO YOU HAVE SUCCESSFUL USE OF THIS EXCEL FEATURE?
|
No.
I write code.
While me writing an export to Excel has great value, forcing my users to have Excel does not.
Sorry.
|
|
|
|
|
05-20-2022, 01:36 PM
|
#8
|
|
@TimeformUSfigs
Join Date: Jan 2002
Location: Moore, OK
Posts: 46,825
|
Quote:
Originally Posted by Dave Schwartz
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.
|
This is like the 1 to 9 explanation.
|
|
|
|
|
05-20-2022, 05:41 PM
|
#9
|
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,900
|
Quote:
Originally Posted by cj
This is like the 1 to 9 explanation.
|
LOL
Agree, but that's all I've got.
|
|
|
|
|
05-20-2022, 06:06 PM
|
#10
|
|
what an easy game.
Join Date: Dec 2002
Posts: 43,096
|
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
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
" I pass with relief from the tossing sea of cause and theory to the firm ground of result and fact"
Winston Churchill
|
|
|
|
|
05-20-2022, 06:07 PM
|
#11
|
|
what an easy game.
Join Date: Dec 2002
Posts: 43,096
|
Quote:
Originally Posted by Dave Schwartz
LOL
Agree, but that's all I've got.
|
as do I
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
" I pass with relief from the tossing sea of cause and theory to the firm ground of result and fact"
Winston Churchill
|
|
|
|
|
05-21-2022, 08:38 AM
|
#12
|
|
Registered User
Join Date: Feb 2003
Posts: 2,105
|
Formula,
Use amwager. They have a "copy data" button that gives you the information without a fancy new Excel feature. Copies to clipboard.
SK
|
|
|
|
|
05-21-2022, 11:03 AM
|
#13
|
|
Registered User
Join Date: Feb 2004
Location: uk
Posts: 372
|
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
|
|
|
|
|
05-21-2022, 11:18 AM
|
#14
|
|
what an easy game.
Join Date: Dec 2002
Posts: 43,096
|
Quote:
Originally Posted by sjk
Formula,
Use amwager. They have a "copy data" button that gives you the information without a fancy new Excel feature. Copies to clipboard.
SK
|
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..
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
" I pass with relief from the tossing sea of cause and theory to the firm ground of result and fact"
Winston Churchill
|
|
|
|
|
05-21-2022, 11:24 AM
|
#15
|
|
what an easy game.
Join Date: Dec 2002
Posts: 43,096
|
Quote:
Originally Posted by zerosky
|
see attached. it has always been checked off.
are you successfully appending excel with any adw's tote board data?
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
" I pass with relief from the tossing sea of cause and theory to the firm ground of result and fact"
Winston Churchill
|
|
|
|
|
|
| Thread Tools |
|
|
| Rate This Thread |
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
