Search results

Yes, that would work. If you clear the table first or do an outer join query, you could do an append to bring in any new records. If you use ADO for the connection, the tricky part is getting all of the data copied down efficiently. I have code I wrote to do this and I'm rewriting it to make is...

A tricky situation has come up and I could really use some help! I am trying to copy files attached to items in a SharePoint list. I have been able to open an ADO connection to the list and pull back a recordset. The Attachments field is a data type of dbLongBinary which is an OLE Object. I need...