[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1193
  • Last Modified:

Microsoft Excel 2007 - Export Table to Sharepoint List - An unexpected error

Task:: to import an EXCEL (.xls) spreadsheet into Sharepoint WSS 3.0

Im using Microsoft Excel 2007. I have succesfully created a Data list.
Next step - Design - Export - Export Table to sharepoint list

Specify address: http://companyweb
Name: Test Sheet
Description: Test Sheet

Step 2 of 2: Column / Data Type / Key Cell
all of those are filled with values from the data list'

Finish: An unexpected error has occured. Changes to your data cannot be saved.
  • 3
1 Solution
Anti-MhzAuthor Commented:
I have tried <customErrors mode="Off" /> in web.config and the CallStack="true" property in the <SharePoint><SafeMode> tag in web.config followed by iisreset /restart

yet im still not getting additional error information. is this problem with excel or sharepoint?
zephyr_hex (Megan)DeveloperCommented:
can you post your data set, please.

Anti-MhzAuthor Commented:
heres a sample. first 5 lines or so
Anti-MhzAuthor Commented:
found a webpart (on codeplex)  that allows importing from the list. that will do just fine.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now