Error in Import data from Excel to SQL Server 2005

Discussion in 'Databases' started by msjawahar, Aug 31, 2008.

0
  1. #1
    Hi all,

    When i import data from excel sheet to sql server 2005, im getting a error

    Error 0xc00470fe Data Flow Task: The product level is insufficient for component SQL Server Import and Export Wizard

    Please advice what can be done with it.

    Thanks in advance

    Steve
     
    msjawahar, Aug 31, 2008 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Try saving the excel file as a csv and import it in that format.
     
    jestep, Sep 3, 2008 IP