Post reply

Insert data into Excel

  • October 5, 2009 at 4:41 am

    #215978

    Hi,

    I would like to insert data into Excel using SQL Statement,

    How is it possible ?

    Cause every where i find for fetching the data from Excel to SQL.

    but i am unable to find info about SQL to EXCEL.

    Please Help me out with this.

    Thanks

    Parth

  • October 5, 2009 at 4:48 am

    #1061634

    http://www.mssqltips.com/tip.asp?tip=1202

    you can use a variety of ways, the article above mentioned some of these.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • October 5, 2009 at 6:31 am

    #1061667

    Hi,

    After following the artical which you gave, i am getting an

    OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Syntax error in FROM clause.".

    Msg 7321, Level 16, State 2, Line 1

    An error occurred while preparing the query "SELECT Name,Date FROM [Sheet1$]" for execution against OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

    P.s : My Excel is there in C Drive + name is also Sheet1

    Thanks

    Parth

  • October 5, 2009 at 6:34 am

    #1061669

    It was Server Client Issue ,

    Now i got it.

    Thanks for the prompt reply.

    Parth

Viewing 4 posts - 1 through 3 (of 3 total)

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