I have been given a connection string which I am told will allow me to connect to a SharePoint list. I wish to connect using DTS in SQL and work with data in the sharepoint list. Can you advise how to set this up? I do not have much experience of DTS and am using wizards and cannot see where or how to use this connection info.
The Connection string : Provider=Microsoft.ACE.OLE