Post reply

Error while uploading data

  • October 8, 2010 at 9:22 am

    #149015

    Hi,

    I am trying to insert the data from the excel file to the sql server database table thru the option sql server import and export table.

    I am gettign error:-

    0xc00470fe:- the product level is insufficient for component.

    I have sql 2005 enterprise edition with sp3 installed.

    SSIS is also installed. excel file is 97-2003 xls extension

    Any guess wats problem

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • October 8, 2010 at 9:39 am

    #1234355

    What is the version of SQL Server 2005. It seems to have resolved in SP1. Read on here[/url]

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • October 8, 2010 at 9:46 am

    #1234361

    @ pradeep

    2005 Enterprise edition with SP3

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • October 8, 2010 at 12:50 pm

    #1234469

    I was on my local pc widout any SSIS installed,

    so I went to remote server and opened management studio and wrote this query :

    SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\Users\xyz\desktop\FullLoad1.2.xls', 'SELECT * FROM [Sheet1$]')

    so, after that I gor error:-

    Cannot process the object "SELECT * FROM [Sheet1$]". The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • October 8, 2010 at 2:12 pm

    #1234519

    Ensure the following

    1. Excel file is on the server where you trying to import

    2. Excel file does not have any spaces in it

    3. Excel file has column names (first row)

    4. Close the file if it is already being used by some other process

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • October 8, 2010 at 2:15 pm

    #1234521

    @ pradeep

    Yup that did it....

    I guess, the excel file was not on the server where I wanted to import.

    Thanks a lot...

    🙂

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • October 8, 2010 at 2:25 pm

    #1234529

    NP.. Good to know it worked!

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply