Welcome Guest
Log In | Register )
You last visited December 3, 2016, 10:50 pm
All times shown are
Eastern Time (GMT-5:00)

Import Drawings into Excel software

Topic closed. 7 replies. Last post 11 years ago by cps10.

Page 1 of 1
PrintE-mailLink
cps10's avatar - Lottery-004.jpg
The Carolinas - Charlotte
United States
Member #21627
September 12, 2005
4138 Posts
Offline
Posted: May 31, 2006, 11:08 am - IP Logged

Does anyone know of a good software that will automatically update drawings and import them into Excel? If possible, maybe by position as well.

The North Carolina Education Lottery - so much a joke that here are their mascots:

Stooges

    lottaloot's avatar - AvatarZ56
    Redford/MI
    United States
    Member #3396
    January 18, 2004
    4867 Posts
    Offline
    Posted: May 31, 2006, 12:49 pm - IP Logged

    If you find the answer to that one, please pm it to me.  Wink

    I think that with the use of VBA, it would be possible; but, I have yet to figure it out. 

    L ttaL   T

      Avatar
      Calgary
      Canada
      Member #9419
      December 7, 2004
      228 Posts
      Offline
      Posted: May 31, 2006, 12:55 pm - IP Logged

      Windows Lotto Pro has it's updated draw data in .dbf format that opens up quite nicely in Excel.  Try it out.  That's the software I use when I need complete updated draw histories.  I believe it has just about every Canada and US lottery.

        cps10's avatar - Lottery-004.jpg
        The Carolinas - Charlotte
        United States
        Member #21627
        September 12, 2005
        4138 Posts
        Offline
        Posted: May 31, 2006, 1:18 pm - IP Logged

        xavier

        Do the numbers come out in positional form in Excel? In other words can you get 3 separate columns for a full number, or is it one field for the 3 digit number?

        The North Carolina Education Lottery - so much a joke that here are their mascots:

        Stooges

          sysp34's avatar - Lottery-062.jpg
          Heroic City
          Indonesia
          Member #31689
          February 2, 2006
          1153 Posts
          Offline
          Posted: May 31, 2006, 1:25 pm - IP Logged

          xavier

          Do the numbers come out in positional form in Excel? In other words can you get 3 separate columns for a full number, or is it one field for the 3 digit number?

          Keith

          if you use excel with lastest MDAC, you will get converted *.dbf from lotto pro 2006 automaticly like this

          Date  P1  P2  P3

           

          well good luck and happy converting *.dbf :)

          sysp34

           

            cps10's avatar - Lottery-004.jpg
            The Carolinas - Charlotte
            United States
            Member #21627
            September 12, 2005
            4138 Posts
            Offline
            Posted: May 31, 2006, 1:27 pm - IP Logged

            sysp

            That sounds great...I need to see what my MDAC is...

            How much is Lotto Pro 2006?

            Keith

            The North Carolina Education Lottery - so much a joke that here are their mascots:

            Stooges

              sysp34's avatar - Lottery-062.jpg
              Heroic City
              Indonesia
              Member #31689
              February 2, 2006
              1153 Posts
              Offline
              Posted: May 31, 2006, 1:46 pm - IP Logged

              sysp

              That sounds great...I need to see what my MDAC is...

              How much is Lotto Pro 2006?

              Keith

              keith,

              MDAC stand for microsoft data access component

              it fix some converted *.dbf into excel. and for daily update you need to purchase lotto pro 2006.

              if i'm not mistaken all lotto pro database use 1997 as fisrt drawings files

              or you can use your's premium membership.

              1. click on each state then copy into text
              2. use excel to delimited with tab and
              3. you have update result is it?

              (i don't know for sure because i haven't tried it. i use one of good software to update result)

              well good luck

              sysp34

                cps10's avatar - Lottery-004.jpg
                The Carolinas - Charlotte
                United States
                Member #21627
                September 12, 2005
                4138 Posts
                Offline
                Posted: May 31, 2006, 1:55 pm - IP Logged

                Thanks sysp ... that is very helpful!

                The North Carolina Education Lottery - so much a joke that here are their mascots:

                Stooges