When I use SharePoint's export to spreadsheet (Excel), not all the columns appear
- by MichaelKay
We have several SharePoint (MOSS) lists with 100's of items so we use 'export to spreadsheet' to do the heavy editing. But, in the spreadsheet not all of the list columns appear. One example is all columns of the 'publishing HTML' type cannot be edited (or even seen) in either Excel 2003 or the web datasheet view. But, an SSIS can export/import these columns without issue.
Is there a way to use Excel 2003/2007 or Access 03/07 to edit these columns. Is there another way to connect to these columns?