Re: Linked SharePoint table missing data.
Strange. I have used linked SharePoint lists in the past, with over 75k records, and have not experienced anything like this.
Have you tried converting the list to a local table, deleting the list, exporting the local table back to your SP site and then re-linking?
“I had the RIGHT to remain silent...but I didn’t have the ABILITY.” - Ron White