Get a file from the web

G

Guest

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.

H
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

QueryTables, some basic questions 5
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
How to get a file from a web page 1
what is the help file for ADO? 1
file access error in opening excel file linked to ms access table 1
How to Copy a list of records into a "TO" field of an email 2
Access Importing csv daily files into access 2007 1
Getting the properties of a file 1

Top