Insert query from Access 2007 to a Sharepoint 2007 list - column has html content RRS feed

  • Question

  • Hi all,

    I try to export entries from an Access 2007 database to a Sharepoint 2007 list. In order to do so, I created a connection from Access to my Sharepoint lists.
    Unfortunately I have an issues with html content:

    One column in my Access table has html content. I want to insert this into a Sharepoint column type "Multiple lines of text" with the additional colum setting "enhanced rich text". I don't get any error with my insert query, but the Sharepoint column is empty.

    INSERT INTO [LISTNAME](Title, Inhalt) VALUES('" & Title.Value & "', '" & Content.Value & "')

    What do I wrong?

    I hope someone can help me with this. Thank you so much in advance!

    Wednesday, August 17, 2011 2:01 PM

All replies