Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 1 down vote accepted

There's no way to use any Office 2003 or 2007 products to edit Publishing HTML fields in SharePoint 2007.

You can, however, download the beta version of Office 2010. You can then connect to the SharePoint lists using Linked Tables in Access which will allow you to edit Publishing HTML fields (which you couldn't do in any previous version).

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .