Can i open remote (http) files for input?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • rmcgregor@firenet.uk.com
    #1

    Can i open remote (http) files for input?

    I want to open remote csv files from within Access XP that are behind
    websites.

    I was trying to do something like this (below) to just show me it could
    see the file and allow me to process it but i get an error...:

    Private Sub Command0_Click( )

    Dim strline

    Open "http://somewhere/filename.CSV" For Input As #1

    Line Input #1, strline

    MsgBox strline, vbOKOnly
    End Sub

    Any ideas on how i have to do this?

    Many thanks,

    Rob.

    Tags: None
    • Tom van Stiphout
      #2
      Re: Can i open remote (http) files for input?

      On 3 Feb 2005 02:13:37 -0800, rmcgregor@firen et.uk.com wrote:

      I would look into the XMLHTTP object. It can be used to request a page
      from some web server.
      -Tom.

      [color=blue]
      >I want to open remote csv files from within Access XP that are behind
      >websites.
      >
      >I was trying to do something like this (below) to just show me it could
      >see the file and allow me to process it but i get an error...:
      >
      >Private Sub Command0_Click( )
      >
      >Dim strline
      >
      >Open "http://somewhere/filename.CSV" For Input As #1
      >
      >Line Input #1, strline
      >
      >MsgBox strline, vbOKOnly
      >End Sub
      >
      >Any ideas on how i have to do this?
      >
      >Many thanks,
      >
      >Rob.[/color]

        Comment

        • Tom van Stiphout
          #3
          Re: Can i open remote (http) files for input?

          On 3 Feb 2005 02:13:37 -0800, rmcgregor@firen et.uk.com wrote:

          Here is another good one: InetTransferLib .
          -Tom.

          [color=blue]
          >I want to open remote csv files from within Access XP that are behind
          >websites.
          >
          >I was trying to do something like this (below) to just show me it could
          >see the file and allow me to process it but i get an error...:
          >
          >Private Sub Command0_Click( )
          >
          >Dim strline
          >
          >Open "http://somewhere/filename.CSV" For Input As #1
          >
          >Line Input #1, strline
          >
          >MsgBox strline, vbOKOnly
          >End Sub
          >
          >Any ideas on how i have to do this?
          >
          >Many thanks,
          >
          >Rob.[/color]

            Comment

            • dkintheuk
              #4
              Re: Can i open remote (http) files for input?

              Thanks Tom,

              InetTransferLib looks favourite and i've just noticed that mvps.org has
              a nice article about it's use.

              Thanks again,

              Rob.

                Comment

                Previous template Next
                Working...