Adding data to an existing list in Sharepoint from Access

[Godders199]

Hello, I have been searching the internet from help, but am still stuck.

I need to start updating an existing sharepoint list from a new access database. I have set up access with the correct column names, for the fields i need populating in the sharepoint list.

I have tried using the move data to sharepoint wizard, using the full Https of the sharepoint list, it completes and states the information has transferred, but there is no trace , if i try again, i see there is a new https with (list 2) at the end within the wizard.

Does anyone have any links to examples of how to add data to an existing sharepoint, rather than a new sharepoint list

Thanks

 

[UncleCatwoman]

I haven't done it in a while but you should be able to connect to an external SharePoint list as an external table (the same way you can an Excel spreadsheet). Then it's just a database table that you can query against or add records to.