Microsoft KB Archive/923591

= Error message when you try to use data from an Excel 2007 workbook or from an Access 2007 database to create a new list in Windows SharePoint Services 3.0: &quot;An unexpected error has occurred&quot; =

Article ID: 923591

Article Last Modified on 5/14/2007

-

APPLIES TO


 * Microsoft Office SharePoint Server 2007
 * Microsoft Windows SharePoint Services 3.0
 * Microsoft Office Access 2007
 * Microsoft Office Excel 2007

-



SYMPTOMS
Consider the following scenario. You try to use data from a Microsoft Office Excel 2007 workbook or from a Microsoft Office Access 2007 database to create a new list in a Microsoft Windows SharePoint Services 3.0 site. To do this, you use any one of the following procedures:
 * You connect to a Windows SharePoint Services 3.0 Web site. Then, you click Import Spreadsheet on the Create page to import data from an Excel 2007 workbook to the list.
 * You open a workbook in Excel 2007, click the Design tab, click Export, and then click Export to List to export data from the workbook to the list.
 * You open a database in Access 2007, click the External Data tab, and then click SharePoint List to export data from the database to the list.

However, you cannot create the list. Instead, you receive an error message that resembles one of the following:

An unexpected error has occurred.

An unexpected error has occurred. Your table cannot be published.



CAUSE
This issue occurs if one of the following conditions is true:
 * You try to import or export more than 231 columns from the Excel 2007 workbook to the Windows SharePoint Services 3.0 list.
 * You try to import or export more than 232 columns from the Access 2007 database to the Windows SharePoint Services 3.0 list.



WORKAROUND
To work around this issue, use one of the following procedures:
 * Use less than 231 columns when you create a list from data in an Excel 2007 workbook.
 * Use less than 232 columns when you create a list from data in an Access 2007 database.



MORE INFORMATION
For more information about how to export data to a Windows SharePoint Services 3.0 list from Excel 2007 or from Access 2007, see Excel 2007 Help or Access 2007 Help.

Additional query words: wss wssv3 moss moss2007 acc2007 xl2007 xls mdb table custom

Keywords: kbexpertisebeginner kbprb kberrmsg kbtshoot kbexpertiseinter KB923591

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.