Skeen
Sep 25th, 2000, 09:10 AM
Hi every 1
I' attempting to automate a program I've written but I've never covered anything like this before.
My program picks up a text file reads each line, splits the line using commas as delimiters andthen inserts the substrings into fields in my database - everything fine up to this point. The problem is, I tested the program by picking up files from a local directory on my PC, but I'm required to retrieve the files in practice from a private ftp site ( with a username and password). I've got various examples from text books but I can't get anything to work.
ie
Inet1,OpenURL("http://www.url.co.uk")
and
With Inet1
.URL = "ftp://www.someFTPsite.com"
.UserName = "John Smith"
.Password = "somePASSword"
.Execute , "DIR"
.Execute , "CLOSE"
End With
The problem is, my books ae very brief regarding ftp controls (4-5 Pages), and I'm at bit of a loss. Can anyone point me in the right direction?
Cheers 'n' beers
Skeen
I' attempting to automate a program I've written but I've never covered anything like this before.
My program picks up a text file reads each line, splits the line using commas as delimiters andthen inserts the substrings into fields in my database - everything fine up to this point. The problem is, I tested the program by picking up files from a local directory on my PC, but I'm required to retrieve the files in practice from a private ftp site ( with a username and password). I've got various examples from text books but I can't get anything to work.
ie
Inet1,OpenURL("http://www.url.co.uk")
and
With Inet1
.URL = "ftp://www.someFTPsite.com"
.UserName = "John Smith"
.Password = "somePASSword"
.Execute , "DIR"
.Execute , "CLOSE"
End With
The problem is, my books ae very brief regarding ftp controls (4-5 Pages), and I'm at bit of a loss. Can anyone point me in the right direction?
Cheers 'n' beers
Skeen