Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board > Thoroughbred Horse Racing Discussion > Handicapping Software


Reply
 
Thread Tools Rate Thread
Old 05-19-2022, 12:58 PM   #1
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 40,766
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
__________________
DON'T LOOK UP


Peace on earth, good will to all
GOD BLESS AMERICA A MUSICAL TRIBUTE
https://www.bing.com/videos/search?q...6FORM%3DVDMHRS

http://EXACTAMATRIX.COM

https://epidemic-stats.com/
formula_2002 is offline   Reply With Quote Reply
Old 05-19-2022, 01:08 PM   #2
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 15,889
What is the error?
Dave Schwartz is offline   Reply With Quote Reply
Old 05-19-2022, 06:48 PM   #3
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 40,766
Quote:
Originally Posted by Dave Schwartz View Post
What is the error?
here it is

Attached Images
File Type: gif get data error.GIF (29.3 KB, 50 views)
__________________
DON'T LOOK UP


Peace on earth, good will to all
GOD BLESS AMERICA A MUSICAL TRIBUTE
https://www.bing.com/videos/search?q...6FORM%3DVDMHRS

http://EXACTAMATRIX.COM

https://epidemic-stats.com/
formula_2002 is offline   Reply With Quote Reply
Old 05-19-2022, 07:20 PM   #4
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 15,889
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.
Dave Schwartz is offline   Reply With Quote Reply
Old 05-19-2022, 08:36 PM   #5
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 40,766
Quote:
Originally Posted by Dave Schwartz View Post
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?
__________________
DON'T LOOK UP


Peace on earth, good will to all
GOD BLESS AMERICA A MUSICAL TRIBUTE
https://www.bing.com/videos/search?q...6FORM%3DVDMHRS

http://EXACTAMATRIX.COM

https://epidemic-stats.com/
formula_2002 is offline   Reply With Quote Reply
Old 05-19-2022, 09:53 PM   #6
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 40,766
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.
__________________
DON'T LOOK UP


Peace on earth, good will to all
GOD BLESS AMERICA A MUSICAL TRIBUTE
https://www.bing.com/videos/search?q...6FORM%3DVDMHRS

http://EXACTAMATRIX.COM

https://epidemic-stats.com/
formula_2002 is offline   Reply With Quote Reply
Old 05-19-2022, 10:02 PM   #7
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 15,889
Quote:
Originally Posted by formula_2002 View Post
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.
Dave Schwartz is offline   Reply With Quote Reply
Old 05-20-2022, 01:36 PM   #8
cj
@TimeformUSfigs
 
cj's Avatar
 
Join Date: Jan 2002
Location: Moore, OK
Posts: 45,822
Quote:
Originally Posted by Dave Schwartz View Post
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.
cj is offline   Reply With Quote Reply
Old 05-20-2022, 05:41 PM   #9
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 15,889
Quote:
Originally Posted by cj View Post
This is like the 1 to 9 explanation.
LOL

Agree, but that's all I've got.
Dave Schwartz is offline   Reply With Quote Reply
Old 05-20-2022, 06:06 PM   #10
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 40,766
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
__________________
DON'T LOOK UP


Peace on earth, good will to all
GOD BLESS AMERICA A MUSICAL TRIBUTE
https://www.bing.com/videos/search?q...6FORM%3DVDMHRS

http://EXACTAMATRIX.COM

https://epidemic-stats.com/
formula_2002 is offline   Reply With Quote Reply
Old 05-20-2022, 06:07 PM   #11
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 40,766
Quote:
Originally Posted by Dave Schwartz View Post
LOL

Agree, but that's all I've got.
as do I
__________________
DON'T LOOK UP


Peace on earth, good will to all
GOD BLESS AMERICA A MUSICAL TRIBUTE
https://www.bing.com/videos/search?q...6FORM%3DVDMHRS

http://EXACTAMATRIX.COM

https://epidemic-stats.com/
formula_2002 is offline   Reply With Quote Reply
Old 05-21-2022, 08:38 AM   #12
sjk
Registered User
 
Join Date: Feb 2003
Posts: 2,059
Formula,

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

SK
sjk is offline   Reply With Quote Reply
Old 05-21-2022, 11:03 AM   #13
zerosky
Registered User
 
Join Date: Feb 2004
Location: uk
Posts: 330
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
zerosky is offline   Reply With Quote Reply
Old 05-21-2022, 11:18 AM   #14
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 40,766
Quote:
Originally Posted by sjk View Post
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..
__________________
DON'T LOOK UP


Peace on earth, good will to all
GOD BLESS AMERICA A MUSICAL TRIBUTE
https://www.bing.com/videos/search?q...6FORM%3DVDMHRS

http://EXACTAMATRIX.COM

https://epidemic-stats.com/
formula_2002 is offline   Reply With Quote Reply
Old 05-21-2022, 11:24 AM   #15
formula_2002
what an easy game.
 
formula_2002's Avatar
 
Join Date: Dec 2002
Posts: 40,766
Quote:
Originally Posted by zerosky View Post
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
see attached. it has always been checked off.
are you successfully appending excel with any adw's tote board data?

Attached Images
File Type: gif excel legacy wizard Capture.GIF (159.9 KB, 13 views)
__________________
DON'T LOOK UP


Peace on earth, good will to all
GOD BLESS AMERICA A MUSICAL TRIBUTE
https://www.bing.com/videos/search?q...6FORM%3DVDMHRS

http://EXACTAMATRIX.COM

https://epidemic-stats.com/
formula_2002 is offline   Reply With Quote Reply
Reply




Thread Tools
Rate This Thread
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

» Advertisement
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 03:24 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2022, vBulletin Solutions, Inc.
Copyright 1999 - 2022 -- PaceAdvantage.Com -- All Rights Reserved
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.