dimanche 8 mars 2015

Export Access table to SP with display control Combo box



I have table in MS Access, that has following lookup properties:

Display control: Combobox

Row source type: Value list

Row source: "Option 1";"Option 2";"Option 3"


And I want export this table to Sharepoint. When I use export from Access (External data, more, Sharepoint) this field works on SP without problem. But I need to use VBA and with following code:



DoCmd.TransferDatabase acExport, "WSS", _
"http://spsite", _
acTable, "tbFromSP", "exportedTable"


field loses this choices and acts like normal text field. Is somehow possible to run export through VBA and not loose this options?








0 commentaires:

Enregistrer un commentaire