AccessForums.net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please join our community, the registration is free and takes only one minute.

Synchronizing to SharePoint causes duplicates

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.