Home Forums SQL Server 2005 T-SQL (SS2K5) OPENROWSET() Intermittently Fails to Read Excel File RE: OPENROWSET() Intermittently Fails to Read Excel File

  • May 19, 2013 at 12:27 pm

    #1616478

    hi,

    I had check following query it is working,

    select * from OPENROWSET('Microsoft.Jet.OLEDB.4.0',

    'Excel 8.0;Database=c:\Employee.xls;',

    'SELECT * FROM [Sheet1$]')

    If any problem ,Let me know.

    Regards,

    Dinesh