Link to home
Start Free TrialLog in
Avatar of Anti-Mhz
Anti-Mhz

asked on

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.
Avatar of Anti-Mhz
Anti-Mhz

ASKER

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?
can you post your data set, please.

thanks.
heres a sample. first 5 lines or so
test.xls
ASKER CERTIFIED SOLUTION
Avatar of Anti-Mhz
Anti-Mhz

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial