Results 1 to 2 of 2
  1. #1
    Flashbond is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    6

    External Data Import from FTP

    Hi Guys!



    I am importing external data from an Excel file. Until today, everything was working fine because I was keeping the revelant Excel file on my local computer. But today, I uploaded it on a secure ftp folder. Now, it throws login error, normally...
    Briefly, I want to call my Excel tables from a password protected ftp.
    How to overcome this?

    Thanks a lot!

  2. #2
    Dal Jeanis is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    Albert Kallal on this thread http://answers.microsoft.com/en-us/o...c-68b599b31bf5
    suggests that you shell out the import routine to bring the file down from the server. The same thread, he gives the URL to an example of an FTP library built in VBA.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-29-2013, 03:08 PM
  2. External Data
    By fabiobarreto10 in forum Programming
    Replies: 2
    Last Post: 12-16-2012, 04:58 AM
  3. External Data Collect Data - email
    By DucDuc in forum Access
    Replies: 1
    Last Post: 01-19-2012, 12:06 AM
  4. Import individual records from external database
    By jimh in forum Import/Export Data
    Replies: 3
    Last Post: 09-13-2011, 04:19 PM
  5. External Data
    By abramenko in forum Import/Export Data
    Replies: 1
    Last Post: 10-14-2009, 12:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums