Skip to content
«
»
 

SQL Server Begin Try

Posted by 
on  June 12 2010

You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “SQL Server Begin Try”.

Filed under TSQL
Comment (RSS)  |  Trackback  |  Permalink

2 Comments

  1. Amos says:
    March 15, 2011 at 8:30 am

    EXCEL IMPORT TO SQL

    Hi,

    I am new to SQL server, and have been struggling with data importation from excel to SQL. I have a 32 bit computer. The code I have used for this import is;

    Create table Test
    GO
    INSERT INTO Test
    SELECT * FROM OPENROWSET(‘Microsoft.Jet.OLEDB.4.0′,
    ‘Excel 12.0;HDR=YES;Database=H:\adhoc\test.xlsx;’,
    ‘SELECT * FROM [Test$]‘)
    GO

    However, it returned the error below;
    OLE DB provider “Microsoft.Jet.OLEDB.4.0″ for linked server “(null)” returned message “Could not find installable ISAM.”.

    I will appreciate your help

    Amos

    Reply to this comment

post a comment OR Post Your Question on our ASK! Community!

«
»