Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Location
    Raleigh, NC
    Posts
    146

    Unanswered: Use Access to check web file

    I have a text file on the web that contains an eight-digit number (68263051). My question is this, is it possible to make Access check this file over a live connection and compare it to data stored in a field. In other words:

    IF "http://www.abc.com/number.txt" = 68263051 THEN
    'Something happens here
    ELSE
    'Something happens here
    END IF

  2. #2
    Join Date
    Feb 2004
    Posts
    137
    You might try something like:
    Code:
    Dim http
    Set http = CreateObject("Microsoft.XMLHTTP")
    http.Open "GET","http://www.abc.com/number.txt", False
    http.Send
    If http.responseText = "68263051" Then
      'Something happens here
    Else
      'Something happens here
    End If
    Set http = Nothing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •