By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,302 Members | 1,716 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,302 IT Pros & Developers. It's quick & easy.

Can i open remote (http) files for input?

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 3 Feb 2005 02:13:37 -0800, rm*******@firenet.uk.com wrote:

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

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.


Nov 13 '05 #2

P: n/a
On 3 Feb 2005 02:13:37 -0800, rm*******@firenet.uk.com wrote:

Here is another good one: InetTransferLib.
-Tom.

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.


Nov 13 '05 #3

P: n/a
Thanks Tom,

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

Thanks again,

Rob.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.