Does anyone have any idea why I am not getting some free text fields from a SharePoint list? I used to get them, but they had a lot of extra characters in the data (Formatting code I'm sure). I think the List owner changed them from Rich Text to Plain text and now my load pulls back nothing. It doesn't error out and say it could find the column.
What is interesting is that when I rebuild the connection using
"https://team.gsk.com/sites/Usability%20Improvements/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLim...{40b2b116-3ae8-442b-8dec-ce68696f3268" I get every column except the ones in question. It's almost as if they have become invisible in the list.
Here's my from statement
FROM [https://team.gsk.com/sites/Usability%20Improvements/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLim...{40b2b116-3ae8-442b-8dec-ce68696f3268}] (XmlSimple, Table is [xml/data/row]);
Ideas?
