If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
importing data from FTP server
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 |
#2
|
|||
|
|||
importing data from FTP server
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 "David Gartrell" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |