Results 1 to 2 of 2
  1. #1
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283

    Importing Data in an Excel file on Sharepoint


    Hi,

    I am trying to import an excel file located on a sharepoint site to a table in my database. All I can seem to do is import the list structure then drill into a hyperlink in that list structure and it opens the file in excel.

    Is there not a way to import the data in that spreadsheet into a table as if you were importing it from your desktop?

    I must be missing something

    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    normally, you can run a macro that has: IMPORTEXPORTSPREADSHEET
    and you assign the path of the excel file to import. Im not sure you can place the path to Sharepoint path.

    you can always make it 2 step:
    1.save the XL sharepoint to local temp folder
    2.import the temp folder file.

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

Similar Threads

  1. Importing Excel file stored on sharepoint
    By tezza79 in forum Import/Export Data
    Replies: 0
    Last Post: 01-27-2015, 01:29 AM
  2. Read excel file from sharepoint site
    By selvakumar.arc in forum Import/Export Data
    Replies: 1
    Last Post: 10-12-2013, 06:34 AM
  3. Importing file directly from a Sharepoint file (not list)
    By jstoler in forum Import/Export Data
    Replies: 1
    Last Post: 06-28-2013, 01:44 PM
  4. Importing and exporting data from a Sharepoint site
    By siddharthnk in forum SharePoint
    Replies: 0
    Last Post: 06-15-2012, 09:28 PM
  5. importing data from an excel file
    By slimjen in forum Access
    Replies: 3
    Last Post: 09-21-2011, 12:38 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