[AccessD] A2003:Connect to a text file at a web address

You can also use this on Win2000 and higher
This works for me using WinHttp when the site uses basic authentication:
There are some other winhttp methods you can use to get around server 
proxies etc.

        Dim objWinHttp as object
        Dim strURL as string
        Dim strHTML as string 'your returned file


        strURL = "http://somesite.com"
        Set objWinHttp = CreateObject("WinHttp.WinHttpRequest.5")

        objWinHttp.Open "GET", strURL
        objWinHttp.SetCredentials "mylogin", "mypasswd", 0
        objWinHttp.Send
        strHTML = objWinHttp.ResponseText
        Set objWinHttp = Nothing

Darren DICK wrote:

>OK Thanks
>
>DD
> 
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
>Sent: Friday, 17 December 2004 3:04 PM
>To: Access Developers discussion and problemsolving
>Subject: Re: [AccessD] A2003:Connect to a text file at a web address
>
>On 17 Dec 2004 at 14:35, Darren DICK wrote:
>
>  
>
>>Hello all
>>I have a text file on my website
>>Very vary small
>>It has one line in it similar to...
>>
>>5.50,True
>>
>>I want to connect to it via link tables When I type in the web address 
>>I get a small dialogue saying Connecting to web server..
>>Then I get an error of LINK TEXT WIZARD: Internet Login Failure
>>
>>Any one know how to pass my logon name and password in this situation?
>>
>>Or if anyone knows of a better situation?
>>
>>    
>>
>
>I don't know about A2003, but according to A2K Help:
>"You cannot import from or link to a Microsoft Access database, a text file,
>or an ODBC data source when importing or linking to an FTP or HTTP server."
>
>
>I'd probably GET the file using FTP and then link to the local copy. 
>
>
>
>--
>Stuart
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada