Retrieving data from a multivalue field in SharePoint to Access

  • Thread starter Thread starter NGP
  • Start date Start date
N

NGP

I am having trouble retrieving data in Access 2007 from a multivalve field in
a SharePoint lists. The records display separated by a special character
instead of separated by a comma. Can anyone help me?
 
NGP said:
I am having trouble retrieving data in Access 2007 from a multivalve field
in
a SharePoint lists. The records display separated by a special character
instead of separated by a comma. Can anyone help me?
Click to expand...

If you want it to display a comma, then you could build a query, and use the
replace() command.

MyCollumn:replace([MvCollum],"~",",")
 
Back
Top