I have an access database that has a button to import data from an specific excel document into a table. The table had Name, and Date as primary keys.
When importing the doc this obviously stops duplicate name/date entries from being added. This is probably a really bad way of doing it but was the way I thought of getting it to work at the time.
I now need to upload my tables to sharepoint. Access isn't able to map to a backend which is hosted on sharepoint so I have created sharepoint lists to hold the table data. Unfortunately sharepoint lists only allow ID auto number as primary key.
What I need to do now is perform some sort of error checking on the import action and I really don't know where to start. I've done some google searching but I've not found a similar question or any tutorial to get started. Could someone please give some advice or point me in the right direction.
Thanks in advance.
When importing the doc this obviously stops duplicate name/date entries from being added. This is probably a really bad way of doing it but was the way I thought of getting it to work at the time.
I now need to upload my tables to sharepoint. Access isn't able to map to a backend which is hosted on sharepoint so I have created sharepoint lists to hold the table data. Unfortunately sharepoint lists only allow ID auto number as primary key.
What I need to do now is perform some sort of error checking on the import action and I really don't know where to start. I've done some google searching but I've not found a similar question or any tutorial to get started. Could someone please give some advice or point me in the right direction.
Thanks in advance.