I have setup a Link between my Access Database and Sharepoint (Moss 3.0). The link allows updates both in the List and the Table when synchronized.
However I am trying to update the Table by importing data from an Excel. I can import the data to the Table, but when I synch with Sharepoint it adds the records twice. When I manually add a record its fine, but I want to add 600+ in one go. When I import the data it shows the Record Id as -1, -2, -3 and gets a new sequential ID from Sharepoint when it connects.
I would be grateful for some assistance.