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