Closed Thread
Results 1 to 2 of 2

Import Data From a Website Database

  1. #1
    Registered User
    Join Date
    01-20-2016
    Location
    Boston, MA
    MS-Off Ver
    Office 2011 Mac
    Posts
    18

    Import Data From a Website Database

    Hello Again Everyone! I hope you are all doing well since the last time I posted.

    I play Massachusetts state keno, and in the past I was able to copy the numbers off the lottery's website, and paste them HORIZONTALLY (from left to right) into rows in Excel which from a function would insert them into their individual columns. Attached below is an example.
    Now the lottery has changed their website, so when I copy the numbers that are horizontal on the website page, they paste vertically from top to bottom into columns on my excel spread sheet instead of horizontally into rows like I have in the Original Example.

    I just found out about Query's, and from the little research I've done, I believe I am looking to run a power query where the data is imported automatically into Excel from the lottery's website. If you could help me, I am looking to import all past & future results.

    Also attached is another example from the 1st 20 games from today 6/26/24.

    So the question I am asking... How can I import the numbers automatically from the lottery's website (past results as well), so that they ship into my excel spreadsheat HORIZONTALLY from left to right? I want the information imported to the right side of the spread sheet beginning with the date.

    Below are the links to the Massachusetts State Lottery keno past draws, as well as a link to Massachusetts State Lottery Data Base for today (I only know how to find the data bases by days, and not all the draws on one page)

    https://www.masslottery.com/tools/pa...sort_by=oldest

    https://www.masslottery.com/api/v1/k...ate=2024-06-26

    I appreciate your help with this issue. Thank you all.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,197

    Re: Import Data From a Website Database

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #2 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...a-website.html

    Thread closed.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Import Data From a Website
    By etm6477 in forum Excel General
    Replies: 5
    Last Post: 06-26-2024, 09:06 PM
  2. import data from website
    By cfirek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-11-2023, 05:31 AM
  3. Replies: 4
    Last Post: 03-24-2021, 03:22 AM
  4. Import website data
    By anavasis in forum Excel General
    Replies: 0
    Last Post: 08-29-2017, 04:07 AM
  5. import data from website using VBA
    By gimer84 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2015, 07:15 AM
  6. import data from a website
    By Bishonen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2012, 06:39 PM
  7. [SOLVED] import data from website
    By Cicada in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2012, 05:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1