RE: import data to excel speadsheet

Reply #7

hypersoniq — Sun, 08 Feb 2004 14:05:05 GMT

michigan is tricky because they limit your query to 1 year of data at a time, so does PAwhen I did PA's data I used MS Word as an intermediate step, because PA had the drawings in descening order by date (new to old) and I wanted them the other way.Step 1. Go back to the first year of michigan daily 3 dataStep 2. Select the entire table on the web page (has the daily 3 logo|date|number on each row)Step 3. Paste into WordStep 4. In Word, select the first column (the logo) and delete it (First tim... [ More ]

Reply #6

Colin F — Sun, 08 Feb 2004 05:30:41 GMT

LottaLoot You're very welcome and thank you for your thank you. The boys in this forum get a bit rowdy now and then but don't you be intimidated by them anyway, they add to the colour (spelt the Ozzy way) of this forum. You only have to read what Pick-4 Master says (always a good read) to see she has to pull them in line now and then. Ask whatever you like thankfully, no one is quoting their credentials here - so you could be getting a reply from anyone including a 10 year old kid who lives aro... [ More ]

Reply #5

Todd — Sat, 07 Feb 2004 11:43:24 GMT

Actually, since Colin is from Australia, it may well be realise for him - not sure if they spell like UK English down under.

Reply #4

vbmx — Sat, 07 Feb 2004 11:35:51 GMT

Quote: Originally posted by Colin F on February 06, 2004 Realise this as well if you can read a Cook Book and write out a recipe for a friend then you know how to program. All you need to do is learn the language you want to program in. realize

Reply #3

lottaloot — Sat, 07 Feb 2004 01:05:28 GMT

Whe

Reply #2

Colin F — Sat, 07 Feb 2004 01:00:20 GMT

LottaLootIf you haven't sorted it out yet tell us where you're taking the History from (Web Page whatever) and I'm sure there are many here who will step you through.Realise this there is no one who is seriously involved with Computers who hasn't done something which took them hours and which they now do in a few minutes.Realise this as well if you can read a Cook Book and write out a recipe for a friend then you know how to program. All you need to do is learn the language you want to program... [ More ]

Reply #1

johnph77 — Wed, 04 Feb 2004 07:35:18 GMT

Depends on the format of the information presented. If it's in a table, it's relatively easy. Just follow the instructions for downloading data from a table in Help. If it's in text form it may require manipulation in a text file editor and possible conversion into a comma separated value (.csv) file.

RE: import data to excel speadsheet

lottaloot — Wed, 04 Feb 2004 03:02:54 GMT

Can anyone tell me how to import lottery history to excel