Import lottery results

Reply #4

orangeanorak — Sun, 04 Jan 2004 16:48:29 GMT

Thanks for your reply. The link you need on my webpage is to click for links to my lottery number checkers. Perhaps I need to design my page better. However below is a link to one of my example pages.http://www.jjnixon.btinternet.co.uk/sample.htm Thanks

Reply #3

orangeanorak — Sun, 04 Jan 2004 16:44:17 GMT

Thanks for your reply hypersonig - I have not expkained my problem fully enough. I do not wish to import the draw history into my spreadsheet, I only want to import the latest draw. I want this to download automatically from the lottery company webpage to my excel sheet that checks my syndicate numbers. I do not want to enter the numbers manually. This may sound lazy but if there is a way to do this automatically I'd like to find it. Thanks for your time.

Reply #2

RJOh — Sun, 04 Jan 2004 16:39:34 GMT

orangeanorak,Went to your webpage, couldn't find a copy of your spreadsheet, just some request for an e-mail address, so I can't help you. Sorry.RJOh

Reply #1

hypersoniq — Sun, 04 Jan 2004 16:31:14 GMT

Not sure how to do what you need... When I created my excel chart for the PA lottery, I used MS WORD as an intermediate step... copied the results right off of the web page, converted text to table , sorted ascending by date (they went the other way) and saved as a text file, from here it was easy to import into excel. This was necessary because PA separates results in pages by year. To copy the entire histories of mid 3, mid 4, eve 3 and eve 4 took less than 20 minutes.When the next draw happe... [ More ]

Import lottery results

orangeanorak — Sun, 04 Jan 2004 15:56:05 GMT

Any one know how to import draw results automatically from a lottery website into an excel spreadsheet which I use for checking my syndicates numbers. The type of spreadsheet I use can be seen on my webpage. Many thanks for your time.