I need to import a CSV file through a url directly into Access 2007. I
can import into Excel then import the excel file into Access, but
can't figure out how to do it directly from Access. Is it even
possible?

Thanks for any help,
JackonLI

JackonLI wrote:
first hit:
Sub testwget()
Dim objHttp As Object
Set objHttp = CreateObject("MSXML2.ServerXMLHTTP")
objHttp.Open "GET", "http://google.com/", False
objHttp.send ""
MsgBox objHttp.responseText
End Sub

Finaly, the responseText is to bee insertet in table - here there is the
choice between saving as file an import using docmd.transfertext or
looping over lines and executing sql insert statements.

On Wed, 27 Apr 2011 19:57:18 +0200, Benny Andersen
<a.mail.user (AT) gmail (DOT) com> wrote:


I don't understand what this is actually doing. Where is the file the
code is retrieving?

-paulw

On Thu, 28 Apr 2011 14:25:16 -0600, PW
<emailaddyinsig (AT) ifIremember (DOT) com> wrote:

Replace google.com with the complete URL to the file.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

On Sun, 01 May 2011 16:56:18 -0600, Tony Toews
<ttoews (AT) telusplanet (DOT) net> wrote:

Now I get it Tony :-) I may want to try this out. And put an updated
file back.

-paul