Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Get a file from the web
0 views
Skip to first unread message
Humphrey
Nov 12, 2007, 8:01:00 PM11/12/07
to
I have a CSV file that is updated overnight and stored on our website. Since
I cannot link to this file in Access I'd like to copy it locally using VBA
and then link to the local copy. This is so I can remain up to date without
having to manually move the file.
Can someone point me in the right direction? I've tried FileSystemObject
and ADODB but cannot get them to work. Searching the web shows the
.CopyRecord method for ADODB but this give me an error when I try it in my
2007 DB.
I cannot link to this file in Access I'd like to copy it locally using VBA
and then link to the local copy. This is so I can remain up to date without
having to manually move the file.
Can someone point me in the right direction? I've tried FileSystemObject
and ADODB but cannot get them to work. Searching the web shows the
.CopyRecord method for ADODB but this give me an error when I try it in my
2007 DB.
H
Alex Dybenko
Nov 13, 2007, 1:03:38 AM11/13/07
to
Hi,
to download file from web server you can use this library:
http://www.mvps.org/access/modules/mdl0037.htm
to download file from web server you can use this library:
http://www.mvps.org/access/modules/mdl0037.htm
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
"Humphrey" <Hump...@discussions.microsoft.com> wrote in message
news:11A187FA-4D75-4D48...@microsoft.com...
0 new messages