Re: Downloading a CSV file from a web site using Access
From: Joe Fallon (jfallon1_at_nospamtwcny.rr.com)
Date: 08/26/04
- Next message: Joe Fallon: "Re: Importing Data into a table that have relationships"
- Previous message: Ashley: "Link Table Manager"
- In reply to: John: "Downloading a CSV file from a web site using Access"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Aug 2004 18:55:39 -0400
You cannot do this from the Access UI.
You need to use FTP in code to copy the file to a local drive and then
import it using normal techniques.
You can use code like this to implement FTP in Access:
http://www.mvps.org/access/modules/mdl0015.htm
-- Joe Fallon Access MVP "John" <jgold@desktoppub.com> wrote in message news:0df901c48ba9$a999a850$a501280a@phx.gbl... >I would like to use Access 2000 to connect with my website > and import a CSV file stored there. I tried to open the > file and connect via FTP, but I received an error > indicating that I didn't have permission to read the file. > > I checked the permissions on the CSV file and it was set > to read/write for all users. > > What am I doing wrong? > > John
- Next message: Joe Fallon: "Re: Importing Data into a table that have relationships"
- Previous message: Ashley: "Link Table Manager"
- In reply to: John: "Downloading a CSV file from a web site using Access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
