importing data from FTP server

[David Gartrell]

Firstly apologies if this is not the correct NG, but i'm not really sure
where best to ask my question!

On a remote FTP server is a data file whose contents I need to import into
an Access 2000 database. Does anyone know of a way of getting Access to
import data directly from an FTP server?

many thanks

David

 

[Michel Walsh]

Hi,


FTP will transfer a file (http://www.mvps.org/access/modules/mdl0015.htm)
but what you do next with this file is up to you.

Even if you get an Excel file, that does NOT mean that each column that
SHOULD have a number have, have, indeed, a number (and not free text ),
or that the column is there, or that the column is in the right order... An
XML file can be a little bit more robust, since it may have been validated
that a number intended is indeed a number written in the file, but even so,
it is not automatic: you download THEN you append the data. To do it in one
step, you would need a Web Service, or something similar, and Access would
have to know about Web Services, in the first place. At the best of my
knowledge, it does not... But two steps let you "feel you are in control"...
even if you are not on the quality of the data...


Hoping it may help,
Vanderghast, Access MVP