asked on

TransferText

I am trying to import a text file from an ftp site but cant seem to get the proper wording. Its in a Macro TransferText action.
I have...

ftp://cmcgregor:pass2000@148.123.2.130/data/SAS/Starii_Extract/cmcgregor/FSAsNotDelivered.txt

in the file name field but it doesnt seem to work. It says ...jet engine could not find the object

ASKER CERTIFIED SOLUTION

stevbe

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cmcgregor

ASKER

I looked at that and dont really understand it at all. I would like to accomplish it through a Macro using TransferText

stevbe

if the line you are using works in windows explorer address bar but not with the TransferText method then I don't think you can do it directly.

The original link requires you to make a .scr file (plain text file with .scr extension instead of .txt) with the FTP commands you want to execute.

Here is another link that contains a complete object model that you can reference in your database and then execute the commands from within your code.
http://www.mvps.org/access/modules/mdl0037.htm

Steve

Steve Bink

No comment has been added to this question in more than 21 days, so it is now classified as abandoned..
I will leave the following recommendation for this question in the Cleanup topic area:

Accept - stevbe

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

RoutineT
EE Cleanup Volunteer

cmcgregor

ASKER

Didnt help me at all but thanks anyway.