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!