Results 1 to 2 of 2
  1. #1
    Simondo is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jun 2014
    Posts
    1

    Link Imported Excel Table to a Standard DataBase Table

    Hi All,

    Newbie to the forum and to Access.

    What I am trying to do is link an Excel 2013 Table I have to SharePoint 2013, Unfortunately Microsoft seem to have removed the feature of linking excel straight to SharePoint. So I am having to try go about this is a roundabout way. Access is great to work with in conjunction with SharePoint, No issues to date until this problem.

    I have linked an Excel table into Access, that works fine and the Access table updates from the excel source, what I want to do now is link that table to SharePoint, however this doesn't seem to be an option. So what I would like to do if there is a way possible, is have my linked excel table feed straight into a standard Access table (which can be linked to SharePoint).

    Been new to Access Im not sure of some of the features, I have tried query's but that doesnt seem to link the tables, and is a once off movement of Data. Im not sure if relationships will do this for, I have tried playing around with them but they dont seem to transfer data.

    I have small experience with VBA if anybody thinks that would be an option, maybe direct VB from excel to access.

    Really trying to think of any way to complete this task

    Any help appreciated,



    Regards,
    Simon

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,818
    If SharePoint won't accept the Excel link or queries based on the link, then seems the only option is import records to a table.

    Why is Excel involved?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 04-29-2014, 05:03 PM
  2. Replies: 3
    Last Post: 03-06-2013, 04:53 PM
  3. Replies: 2
    Last Post: 03-28-2012, 11:35 AM
  4. Linking Access Table with already imported External Data (Excel)
    By izzarshah in forum Import/Export Data
    Replies: 1
    Last Post: 07-29-2010, 09:40 AM
  5. link excel form to access table
    By data123 in forum Import/Export Data
    Replies: 6
    Last Post: 06-23-2006, 10:17 AM

Tags for this Thread

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