Insert query from Access 2007 to a Sharepoint 2007 list

[Caessa]

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 issues with two things:

1. issue: I have two lookup fields in the Sharepoint list, where you can choose more than one option (multiple lookup). I don't know how I have to build my query for this. I tried these two things:

INSERT INTO [LISTNAME](Kategorie) VALUES(31)
-> I get the error "An INSERT INTO query cannot contain a multi-valued field"

INSERT INTO [LISTNAME](Kategorie.Value) VALUES(31)
-> Access doesn't respond anymore an I have to close it

Lookup fields, that can contain only one value, are workin fine.


2. issue: 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!

Regards
Nicole