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
cmcgregorAsked:
Who is Participating?
 
stevbeCommented:
I use code to pull the file via FTP before I import. You can find code for FTP at ...
http://www.mvps.org/access/modules/mdl0015.htm

Steve
0
 
cmcgregorAuthor Commented:
I looked at that and dont really understand it at all. I would like to accomplish it through a Macro using TransferText
0
 
stevbeCommented:
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
0
 
Steve BinkCommented:
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

0
 
cmcgregorAuthor Commented:
Didnt help me at all but thanks anyway.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.