I have an Excel workbook table that saves entries to local Access table. It was good. Now, I tried to export the Access table to SharePoint. It was successfully uploaded. Now when I tried to input entries from Excel, I can see that .accdb file has a timestamp that it has been modified and its file size is added, too. But when I open the table, it is empty, no records found.


Click image for larger version.  Name: 2023-11-20_10-11-20.png  Views: 7  Size: 6.3 KB  ID: 51069

Click image for larger version.  Name: 2023-11-20_10-32-41.png  Views: 7  Size: 6.9 KB  ID: 51070

The only difference is that, before Access table was uploaded, it has same headers with Excel table.

Original Headers/Fields




Click image for larger version.  Name: 2023-11-20_10-33-32.png  Views: 7  Size: 8.4 KB  ID: 51071

But when table was exported to SharePoint, there were more headers added.

Click image for larger version.  Name: 2023-11-20_10-07-16.png  Views: 7  Size: 12.3 KB  ID: 51072


I tried to copy those added headers to Excel and try to save entries from Excel but .accdb table still shows it is modified and just blank table.

Click image for larger version.  Name: 2023-11-20_10-32-41.png  Views: 7  Size: 6.9 KB  ID: 51070