Results 1 to 2 of 2
  1. #1
    Robeen is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596

    Import From Excel Spreadsheet on Sharepoint Site.

    Hi,



    I'm using MS Access 2007.
    Is it possible to import data from Excel spreadsheets that are on a SharePoint Site? If so, how?

    The message I get when I try and 'Get External Data' is: 'Only XML files can be imported from an Internet address ...'.
    It is a very unequivocal message but I thought I'd ask anyway.

    Thanks!!

  2. #2
    Deprecate is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    3
    You have to remove the 'http:', in Access 2010 this works. Not tested on 2007 though.

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

Similar Threads

  1. How to access excel file from sharepoint site
    By selvakumar.arc in forum Forms
    Replies: 0
    Last Post: 07-22-2014, 11:18 AM
  2. Excel Import - Check if Spreadsheet Exists
    By kagoodwin13 in forum Programming
    Replies: 3
    Last Post: 11-21-2013, 02:38 PM
  3. Read excel file from sharepoint site
    By selvakumar.arc in forum Import/Export Data
    Replies: 1
    Last Post: 10-12-2013, 06:34 AM
  4. Replies: 0
    Last Post: 09-26-2012, 12:20 PM
  5. import excel spreadsheet though outlook
    By bopsgtir in forum Import/Export Data
    Replies: 0
    Last Post: 03-18-2011, 09:07 AM

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