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

Posted on 2009-12-22
Last Modified: 2012-05-08
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.
Question by:Anti-Mhz
    LVL 1

    Author Comment

    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?
    LVL 42

    Expert Comment

    can you post your data set, please.

    LVL 1

    Author Comment

    heres a sample. first 5 lines or so
    LVL 1

    Accepted Solution

    found a webpart (on codeplex)  that allows importing from the list. that will do just fine.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now