locked
Insert query from Access 2007 to a Sharepoint 2007 list 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 issue.


    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.



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

    Regards
    Nicole


    • Edited by Mike Walsh FIN Wednesday, August 17, 2011 9:27 AM Ask one question pr thread. Post the second question as a new thread
    Wednesday, August 17, 2011 9:07 AM

Answers