Post reply

Export SQL Server 2005 Table to Excel 2007 using T-SQL

  • July 8, 2015 at 8:36 am

    #1810977

    Hi. the Message

    OLE DB error trace [Non-interface error: Provider not registered.].

    Msg 7403, Level 16, State 1, Line 1

    Could not locate registry entry for OLE DB provider 'Microsoft.ACE.OLEDB.12.0'.

    is because you have to create the file excel with the appropriate header , if not add this code HDR = YES ;

    example

    INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0',

    'Excel 12.0;HDR=YES;Database=C:\Test\Book1.xlsx;',

    'SELECT * FROM [Sheet1$]') SELECT EmployeeId from dbo.Employees

    😀

Viewing post 16 (of 15 total)

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