Results 1 to 3 of 3
  1. #1
    PJ Crittenden is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2014
    Posts
    22

    Slow upload from Access to SharePoint

    It took almost two hours to upload approx 12,000 lines of simple data...no memo fields, just some text and currenty. This was one table to append...did not require any joins. Just append. After about two hours, I got the message System Resources Exceeded and only about 8,000 lines of data loaded. I had to do a query to figure out what didn't load, export them to Excel and then Copy/Paste. What a pain!

    I don't know if this is an Access issue, a network issue, or a SharePoint issue. All I know is I can't get any help.

    If anyone has a suggestion, I'd sure appreciate it!

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I've done this before...I think SharePoint issue. Never resolved the slowness.

    As for what loaded, youd need to run an outer join query on the table uploaded and match to the local table, to see whats missing.

  3. #3
    PJ Crittenden is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2014
    Posts
    22
    Thanks ranman256. I ran a query from Access to identify what didn't load, exported them to Excel and then did a copy/paste.

    Someone suggested I have an Indexed column, autonumber. Not sure if that could help but hey, I'm willing to try anything at this point.

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

Similar Threads

  1. Custom upload data to Access from Excel
    By ketangarg86 in forum Access
    Replies: 1
    Last Post: 09-09-2014, 02:06 PM
  2. Slow access tables linked to sharepoint. How to fix it?
    By flamingos_usa in forum SharePoint
    Replies: 3
    Last Post: 05-03-2014, 09:36 AM
  3. Replies: 7
    Last Post: 10-28-2013, 08:49 AM
  4. Upload Report to SharePoint Library
    By Lorlai in forum SharePoint
    Replies: 2
    Last Post: 09-22-2011, 01:39 PM
  5. Upload files to access 2007 through web
    By karthikcoep in forum Programming
    Replies: 0
    Last Post: 08-23-2009, 10:04 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