bump........... .

We're currently using Sharepoint to pull data into Access, so our tables are linked. In our tables in Access we are getting extra characters (;#) in our data that needs to be removed. I'm assuming that the extra characters are coming from the information in Sharepoint as the field is a checkbox field with multiple selections possible.

The way it looks:

Sharepoint -> Name; Name2; Name 3
Access -> ;#Name;#Name2;# Name3;#...