+ Reply to Thread
Results 1 to 3 of 3

Access external data

  1. #1
    Registered User
    Join Date
    04-23-2015
    Location
    Rishon
    MS-Off Ver
    2007
    Posts
    10

    Access external data

    Hi,

    I'm trying to make Excel sheet updating from external Excel file.
    I'm using Data > Get External Data > Other Sources > Microsoft Query > Excel files
    From here I can get the external data when the Excel file (containing the external data) is on a drive recognized by the computer (e.g. C: ).
    But when I'm trying to get Excel file from the Internet, it does not work.

    For example, my file 'example.xlsx' is located in
    ftp://100.101.102.103

    I tried to select 'Network' in the Query option, making all the necessary operations, but it does not work.

    Anyone has an idea ?

    Thanks,
    Haim

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Access external data

    Data > Get External Data > From Web

    Try by launching from that dialogue box instead.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Registered User
    Join Date
    04-23-2015
    Location
    Rishon
    MS-Off Ver
    2007
    Posts
    10

    Re: Access external data

    Thank you Ben,
    When I select From the Web, and entering the full link with the file name, i.e. ftp://......../example.xlsx , a pop-up windows asks for the ftp user and password.
    I enter the correct data, but it refuses to accept it and asks again for the user and password.

    Haim.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Identify external workbooks that access my data
    By jacob@thepenpoint in forum Excel General
    Replies: 1
    Last Post: 02-08-2016, 10:59 AM
  2. Get External Data From Access—Column Empty
    By MishaJames1972 in forum Access Tables & Databases
    Replies: 1
    Last Post: 02-03-2016, 07:33 PM
  3. External Data - Crosstab Query Access
    By RobLmrcpvf in forum Excel General
    Replies: 2
    Last Post: 06-28-2011, 12:44 PM
  4. [external data] Two queries same access files...
    By El_Pablo in forum Excel General
    Replies: 0
    Last Post: 10-31-2008, 03:04 PM
  5. [SOLVED] MONTHNAME when getting external data from Access
    By -PJ in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2006, 03:55 PM
  6. [SOLVED] Get external data from MS Access using variables
    By RTP in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-10-2006, 10:25 PM
  7. [SOLVED] Getting external data from Access to Excel
    By Veli Izzet in forum Excel General
    Replies: 6
    Last Post: 07-22-2005, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1