Can MS Access connect and download from the internet?

B

Brook

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
 
A

Arvin Meyer [MVP]

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
 
B

Brook

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
 
D

Douglas J. Steele

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

(no e-mails, please!)
 
B

Brook

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
 
D

Douglas J. Steele

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)
 
D

Douglas J. Steele

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

Arvin Meyer [MVP]

Sent too soon:

Arvin Meyer said:
Try this: Put a command button on a form. Call it cmdWhatever as paste the
following code in a module:
Click to expand...

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
 
B

Brook

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
 
D

Douglas J Steele

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

Use INSERT INTO queries to populate a table.
 
Top