Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Can MS Access connect and download from the internet?

Discussion in 'Information Technology' started by Brook, Nov 5, 2005.

  1. Brook

    Brook
    Expand Collapse
    Guest

    Good Day All,

    I was wanting to set up a database of my stocks / mutual funds in a DB
    and upon opening and or command button connect to the internet and download
    the current rates for the funds listed in my table?

    Is this at all possible?

    Thanks,

    Brook
     
  2. Loading...


  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    I have been able to do that with a computer hardware price site, but I have
    had to copy and paste the current price. Sore the link in your database and
    follow the hyperlink to the website in it's click event.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Brook" <Brook@discussions.microsoft.com> wrote in message
    news:A91C09A6-E349-4BA3-8F79-11A14AF1C94D@microsoft.com...
    > Good Day All,
    >
    > I was wanting to set up a database of my stocks / mutual funds in a DB
    > and upon opening and or command button connect to the internet and

    download
    > the current rates for the funds listed in my table?
    >
    > Is this at all possible?
    >
    > Thanks,
    >
    > Brook
     
  4. Brook

    Brook
    Expand Collapse
    Guest

    Good DAy...

    Thanks for the response and and sorry i'm late in responding... Do you have
    an example of what you did? I am usure what your refering too?

    Thanks,

    BRook

    "Arvin Meyer [MVP]" wrote:

    > I have been able to do that with a computer hardware price site, but I have
    > had to copy and paste the current price. Sore the link in your database and
    > follow the hyperlink to the website in it's click event.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "Brook" <Brook@discussions.microsoft.com> wrote in message
    > news:A91C09A6-E349-4BA3-8F79-11A14AF1C94D@microsoft.com...
    > > Good Day All,
    > >
    > > I was wanting to set up a database of my stocks / mutual funds in a DB
    > > and upon opening and or command button connect to the internet and

    > download
    > > the current rates for the funds listed in my table?
    > >
    > > Is this at all possible?
    > >
    > > Thanks,
    > >
    > > Brook

    >
    >
    >
     
  5. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    What Arvin's talking about is using the FollowHyperlink method to allow you
    to open your browser at the page in question.

    If what you're trying to do is capture the information from that page, you
    could take a look at my November, 2003 "Access Answers" column in Pinnacle
    Publication's "Smart Access". You can download the column (and sample
    database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html
    Unfortunately, the two sites I used to illustrate the technique have changed
    since I wrote the column, so the sample database doesn't actually work
    anymore. Hopefully reading the column and seeing the code will be enough to
    help you figure it out.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)



    "Brook" <Brook@discussions.microsoft.com> wrote in message
    news:EDB41882-9D17-42F7-98B0-E477BDA07BB4@microsoft.com...
    > Good DAy...
    >
    > Thanks for the response and and sorry i'm late in responding... Do you
    > have
    > an example of what you did? I am usure what your refering too?
    >
    > Thanks,
    >
    > BRook
    >
    > "Arvin Meyer [MVP]" wrote:
    >
    >> I have been able to do that with a computer hardware price site, but I
    >> have
    >> had to copy and paste the current price. Sore the link in your database
    >> and
    >> follow the hyperlink to the website in it's click event.
    >> --
    >> Arvin Meyer, MCP, MVP
    >> Microsoft Access
    >> Free Access downloads
    >> http://www.datastrat.com
    >> http://www.mvps.org/access
    >>
    >> "Brook" <Brook@discussions.microsoft.com> wrote in message
    >> news:A91C09A6-E349-4BA3-8F79-11A14AF1C94D@microsoft.com...
    >> > Good Day All,
    >> >
    >> > I was wanting to set up a database of my stocks / mutual funds in a
    >> > DB
    >> > and upon opening and or command button connect to the internet and

    >> download
    >> > the current rates for the funds listed in my table?
    >> >
    >> > Is this at all possible?
    >> >
    >> > Thanks,
    >> >
    >> > Brook

    >>
    >>
    >>
     
  6. Brook

    Brook
    Expand Collapse
    Guest

    Thanks for the Clarification...

    So, there is not a way for Access to directly link and download from the
    internet?

    What if I could set it up to where I would download a file from the net on
    a daily/bidaily basis and import it into my db?

    Brook

    "Douglas J. Steele" wrote:

    > What Arvin's talking about is using the FollowHyperlink method to allow you
    > to open your browser at the page in question.
    >
    > If what you're trying to do is capture the information from that page, you
    > could take a look at my November, 2003 "Access Answers" column in Pinnacle
    > Publication's "Smart Access". You can download the column (and sample
    > database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html
    > Unfortunately, the two sites I used to illustrate the technique have changed
    > since I wrote the column, so the sample database doesn't actually work
    > anymore. Hopefully reading the column and seeing the code will be enough to
    > help you figure it out.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    >
    > "Brook" <Brook@discussions.microsoft.com> wrote in message
    > news:EDB41882-9D17-42F7-98B0-E477BDA07BB4@microsoft.com...
    > > Good DAy...
    > >
    > > Thanks for the response and and sorry i'm late in responding... Do you
    > > have
    > > an example of what you did? I am usure what your refering too?
    > >
    > > Thanks,
    > >
    > > BRook
    > >
    > > "Arvin Meyer [MVP]" wrote:
    > >
    > >> I have been able to do that with a computer hardware price site, but I
    > >> have
    > >> had to copy and paste the current price. Sore the link in your database
    > >> and
    > >> follow the hyperlink to the website in it's click event.
    > >> --
    > >> Arvin Meyer, MCP, MVP
    > >> Microsoft Access
    > >> Free Access downloads
    > >> http://www.datastrat.com
    > >> http://www.mvps.org/access
    > >>
    > >> "Brook" <Brook@discussions.microsoft.com> wrote in message
    > >> news:A91C09A6-E349-4BA3-8F79-11A14AF1C94D@microsoft.com...
    > >> > Good Day All,
    > >> >
    > >> > I was wanting to set up a database of my stocks / mutual funds in a
    > >> > DB
    > >> > and upon opening and or command button connect to the internet and
    > >> download
    > >> > the current rates for the funds listed in my table?
    > >> >
    > >> > Is this at all possible?
    > >> >
    > >> > Thanks,
    > >> >
    > >> > Brook
    > >>
    > >>
    > >>

    >
    >
    >
     
  7. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Access does recognize either the FTP nor HTTP protocols, so no, there's no
    way for Access to link directly.

    You can use the programmatic approach I outlined in the article I cited, or
    if you can download the file from the web, then yes, you can interact with
    it as you do with any other local file. (FWIW, there's code at "The Access
    Web" to help kick off FTPs from Access: see
    http://www.mvps.org/access/modules/mdl0015.htm and
    http://www.mvps.org/access/modules/mdl0037.htm)

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)



    "Brook" <Brook@discussions.microsoft.com> wrote in message
    news:39420BD8-F200-485C-9F51-F34A9E547098@microsoft.com...
    > Thanks for the Clarification...
    >
    > So, there is not a way for Access to directly link and download from the
    > internet?
    >
    > What if I could set it up to where I would download a file from the net on
    > a daily/bidaily basis and import it into my db?
    >
    > Brook
    >
    > "Douglas J. Steele" wrote:
    >
    >> What Arvin's talking about is using the FollowHyperlink method to allow
    >> you
    >> to open your browser at the page in question.
    >>
    >> If what you're trying to do is capture the information from that page,
    >> you
    >> could take a look at my November, 2003 "Access Answers" column in
    >> Pinnacle
    >> Publication's "Smart Access". You can download the column (and sample
    >> database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html
    >> Unfortunately, the two sites I used to illustrate the technique have
    >> changed
    >> since I wrote the column, so the sample database doesn't actually work
    >> anymore. Hopefully reading the column and seeing the code will be enough
    >> to
    >> help you figure it out.
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no e-mails, please!)
    >>
    >>
    >>
    >> "Brook" <Brook@discussions.microsoft.com> wrote in message
    >> news:EDB41882-9D17-42F7-98B0-E477BDA07BB4@microsoft.com...
    >> > Good DAy...
    >> >
    >> > Thanks for the response and and sorry i'm late in responding... Do you
    >> > have
    >> > an example of what you did? I am usure what your refering too?
    >> >
    >> > Thanks,
    >> >
    >> > BRook
    >> >
    >> > "Arvin Meyer [MVP]" wrote:
    >> >
    >> >> I have been able to do that with a computer hardware price site, but I
    >> >> have
    >> >> had to copy and paste the current price. Sore the link in your
    >> >> database
    >> >> and
    >> >> follow the hyperlink to the website in it's click event.
    >> >> --
    >> >> Arvin Meyer, MCP, MVP
    >> >> Microsoft Access
    >> >> Free Access downloads
    >> >> http://www.datastrat.com
    >> >> http://www.mvps.org/access
    >> >>
    >> >> "Brook" <Brook@discussions.microsoft.com> wrote in message
    >> >> news:A91C09A6-E349-4BA3-8F79-11A14AF1C94D@microsoft.com...
    >> >> > Good Day All,
    >> >> >
    >> >> > I was wanting to set up a database of my stocks / mutual funds
    >> >> > in a
    >> >> > DB
    >> >> > and upon opening and or command button connect to the internet and
    >> >> download
    >> >> > the current rates for the funds listed in my table?
    >> >> >
    >> >> > Is this at all possible?
    >> >> >
    >> >> > Thanks,
    >> >> >
    >> >> > Brook
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  8. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Oops, typo. That should read "Access does NOT recognize either the FTP nor
    HTTP protocols..."

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)



    "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:%23GF1z6u4FHA.3136@TK2MSFTNGP09.phx.gbl...
    > Access does recognize either the FTP nor HTTP protocols, so no, there's no
    > way for Access to link directly.
    >
    > You can use the programmatic approach I outlined in the article I cited,
    > or if you can download the file from the web, then yes, you can interact
    > with it as you do with any other local file. (FWIW, there's code at "The
    > Access Web" to help kick off FTPs from Access: see
    > http://www.mvps.org/access/modules/mdl0015.htm and
    > http://www.mvps.org/access/modules/mdl0037.htm)
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    >
    > "Brook" <Brook@discussions.microsoft.com> wrote in message
    > news:39420BD8-F200-485C-9F51-F34A9E547098@microsoft.com...
    >> Thanks for the Clarification...
    >>
    >> So, there is not a way for Access to directly link and download from the
    >> internet?
    >>
    >> What if I could set it up to where I would download a file from the net
    >> on
    >> a daily/bidaily basis and import it into my db?
    >>
    >> Brook
    >>
    >> "Douglas J. Steele" wrote:
    >>
    >>> What Arvin's talking about is using the FollowHyperlink method to allow
    >>> you
    >>> to open your browser at the page in question.
    >>>
    >>> If what you're trying to do is capture the information from that page,
    >>> you
    >>> could take a look at my November, 2003 "Access Answers" column in
    >>> Pinnacle
    >>> Publication's "Smart Access". You can download the column (and sample
    >>> database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html
    >>> Unfortunately, the two sites I used to illustrate the technique have
    >>> changed
    >>> since I wrote the column, so the sample database doesn't actually work
    >>> anymore. Hopefully reading the column and seeing the code will be enough
    >>> to
    >>> help you figure it out.
    >>>
    >>> --
    >>> Doug Steele, Microsoft Access MVP
    >>> http://I.Am/DougSteele
    >>> (no e-mails, please!)
    >>>
    >>>
    >>>
    >>> "Brook" <Brook@discussions.microsoft.com> wrote in message
    >>> news:EDB41882-9D17-42F7-98B0-E477BDA07BB4@microsoft.com...
    >>> > Good DAy...
    >>> >
    >>> > Thanks for the response and and sorry i'm late in responding... Do you
    >>> > have
    >>> > an example of what you did? I am usure what your refering too?
    >>> >
    >>> > Thanks,
    >>> >
    >>> > BRook
    >>> >
    >>> > "Arvin Meyer [MVP]" wrote:
    >>> >
    >>> >> I have been able to do that with a computer hardware price site, but
    >>> >> I
    >>> >> have
    >>> >> had to copy and paste the current price. Sore the link in your
    >>> >> database
    >>> >> and
    >>> >> follow the hyperlink to the website in it's click event.
    >>> >> --
    >>> >> Arvin Meyer, MCP, MVP
    >>> >> Microsoft Access
    >>> >> Free Access downloads
    >>> >> http://www.datastrat.com
    >>> >> http://www.mvps.org/access
    >>> >>
    >>> >> "Brook" <Brook@discussions.microsoft.com> wrote in message
    >>> >> news:A91C09A6-E349-4BA3-8F79-11A14AF1C94D@microsoft.com...
    >>> >> > Good Day All,
    >>> >> >
    >>> >> > I was wanting to set up a database of my stocks / mutual funds
    >>> >> > in a
    >>> >> > DB
    >>> >> > and upon opening and or command button connect to the internet and
    >>> >> download
    >>> >> > the current rates for the funds listed in my table?
    >>> >> >
    >>> >> > Is this at all possible?
    >>> >> >
    >>> >> > Thanks,
    >>> >> >
    >>> >> > Brook
    >>> >>
    >>> >>
    >>> >>
    >>>
    >>>
    >>>

    >
    >
     
  9. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Try this: Put a command button on a form. Call it cmdWhatever as paste the
    following code in a module:

    Private Sub Command0_Click()
    Application.FollowHyperlink
    ("http://www.cdw.com/shop/products/default.aspx?EDC=541083")
    End Sub
    "Brook" <Brook@discussions.microsoft.com> wrote in message
    news:EDB41882-9D17-42F7-98B0-E477BDA07BB4@microsoft.com...
    > Good DAy...
    >
    > Thanks for the response and and sorry i'm late in responding... Do you

    have
    > an example of what you did? I am usure what your refering too?
    >
    > Thanks,
    >
    > BRook
    >
    > "Arvin Meyer [MVP]" wrote:
    >
    > > I have been able to do that with a computer hardware price site, but I

    have
    > > had to copy and paste the current price. Sore the link in your database

    and
    > > follow the hyperlink to the website in it's click event.
    > > --
    > > Arvin Meyer, MCP, MVP
    > > Microsoft Access
    > > Free Access downloads
    > > http://www.datastrat.com
    > > http://www.mvps.org/access
    > >
    > > "Brook" <Brook@discussions.microsoft.com> wrote in message
    > > news:A91C09A6-E349-4BA3-8F79-11A14AF1C94D@microsoft.com...
    > > > Good Day All,
    > > >
    > > > I was wanting to set up a database of my stocks / mutual funds in

    a DB
    > > > and upon opening and or command button connect to the internet and

    > > download
    > > > the current rates for the funds listed in my table?
    > > >
    > > > Is this at all possible?
    > > >
    > > > Thanks,
    > > >
    > > > Brook

    > >
    > >
    > >
     
  10. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Sent too soon:

    "Arvin Meyer [MVP]" <a@m.com> wrote in message
    news:#Yuj7Px4FHA.3876@TK2MSFTNGP09.phx.gbl...
    > Try this: Put a command button on a form. Call it cmdWhatever as paste the
    > following code in a module:


    Private Sub cmdWhatever_Click()
    Application.FollowHyperlink
    ("http://www.cdw.com/shop/products/default.aspx?EDC=541083")
    End Sub

    Try the button. Then add a field to the table and a text box to the form to
    hold the URL and change the code to reflect that:

    Private Sub cmdWhatever_Click()
    Application.FollowHyperlink & Me.txtHyperlink
    End Sub

    It will get you to the webpage that you want, but you will need to copy the
    data from that page and paste it into your application.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access
     
  11. Brook

    Brook
    Expand Collapse
    Guest

    Hello Douglas,

    Well, this is close to what i'm trying to accomplish, but would it be
    possible to not only obtain the information from the site, but also to write
    it to a tbl for reporting / comparision purposes?

    Brook

    "Douglas J. Steele" wrote:

    > What Arvin's talking about is using the FollowHyperlink method to allow you
    > to open your browser at the page in question.
    >
    > If what you're trying to do is capture the information from that page, you
    > could take a look at my November, 2003 "Access Answers" column in Pinnacle
    > Publication's "Smart Access". You can download the column (and sample
    > database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html
    > Unfortunately, the two sites I used to illustrate the technique have changed
    > since I wrote the column, so the sample database doesn't actually work
    > anymore. Hopefully reading the column and seeing the code will be enough to
    > help you figure it out.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    >
    > "Brook" <Brook@discussions.microsoft.com> wrote in message
    > news:EDB41882-9D17-42F7-98B0-E477BDA07BB4@microsoft.com...
    > > Good DAy...
    > >
    > > Thanks for the response and and sorry i'm late in responding... Do you
    > > have
    > > an example of what you did? I am usure what your refering too?
    > >
    > > Thanks,
    > >
    > > BRook
    > >
    > > "Arvin Meyer [MVP]" wrote:
    > >
    > >> I have been able to do that with a computer hardware price site, but I
    > >> have
    > >> had to copy and paste the current price. Sore the link in your database
    > >> and
    > >> follow the hyperlink to the website in it's click event.
    > >> --
    > >> Arvin Meyer, MCP, MVP
    > >> Microsoft Access
    > >> Free Access downloads
    > >> http://www.datastrat.com
    > >> http://www.mvps.org/access
    > >>
    > >> "Brook" <Brook@discussions.microsoft.com> wrote in message
    > >> news:A91C09A6-E349-4BA3-8F79-11A14AF1C94D@microsoft.com...
    > >> > Good Day All,
    > >> >
    > >> > I was wanting to set up a database of my stocks / mutual funds in a
    > >> > DB
    > >> > and upon opening and or command button connect to the internet and
    > >> download
    > >> > the current rates for the funds listed in my table?
    > >> >
    > >> > Is this at all possible?
    > >> >
    > >> > Thanks,
    > >> >
    > >> > Brook
    > >>
    > >>
    > >>

    >
    >
    >
     
  12. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Once you've read the data into memory, you can do whatever you want with it!

    Use INSERT INTO queries to populate a table.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Brook" <Brook@discussions.microsoft.com> wrote in message
    news:C18AE161-C12D-4EC5-A170-C546386F8535@microsoft.com...
    > Hello Douglas,
    >
    > Well, this is close to what i'm trying to accomplish, but would it be
    > possible to not only obtain the information from the site, but also to

    write
    > it to a tbl for reporting / comparision purposes?
    >
    > Brook
    >
    > "Douglas J. Steele" wrote:
    >
    > > What Arvin's talking about is using the FollowHyperlink method to allow

    you
    > > to open your browser at the page in question.
    > >
    > > If what you're trying to do is capture the information from that page,

    you
    > > could take a look at my November, 2003 "Access Answers" column in

    Pinnacle
    > > Publication's "Smart Access". You can download the column (and sample
    > > database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html
    > > Unfortunately, the two sites I used to illustrate the technique have

    changed
    > > since I wrote the column, so the sample database doesn't actually work
    > > anymore. Hopefully reading the column and seeing the code will be enough

    to
    > > help you figure it out.
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > >
    > > "Brook" <Brook@discussions.microsoft.com> wrote in message
    > > news:EDB41882-9D17-42F7-98B0-E477BDA07BB4@microsoft.com...
    > > > Good DAy...
    > > >
    > > > Thanks for the response and and sorry i'm late in responding... Do you
    > > > have
    > > > an example of what you did? I am usure what your refering too?
    > > >
    > > > Thanks,
    > > >
    > > > BRook
    > > >
    > > > "Arvin Meyer [MVP]" wrote:
    > > >
    > > >> I have been able to do that with a computer hardware price site, but

    I
    > > >> have
    > > >> had to copy and paste the current price. Sore the link in your

    database
    > > >> and
    > > >> follow the hyperlink to the website in it's click event.
    > > >> --
    > > >> Arvin Meyer, MCP, MVP
    > > >> Microsoft Access
    > > >> Free Access downloads
    > > >> http://www.datastrat.com
    > > >> http://www.mvps.org/access
    > > >>
    > > >> "Brook" <Brook@discussions.microsoft.com> wrote in message
    > > >> news:A91C09A6-E349-4BA3-8F79-11A14AF1C94D@microsoft.com...
    > > >> > Good Day All,
    > > >> >
    > > >> > I was wanting to set up a database of my stocks / mutual funds

    in a
    > > >> > DB
    > > >> > and upon opening and or command button connect to the internet and
    > > >> download
    > > >> > the current rates for the funds listed in my table?
    > > >> >
    > > >> > Is this at all possible?
    > > >> >
    > > >> > Thanks,
    > > >> >
    > > >> > Brook
    > > >>
    > > >>
    > > >>

    > >
    > >
    > >
     

Share This Page