Home Forums SQL Server 2005 SQL Server 2005 General Discussion Openrowset access to Excel 2007 RE: Openrowset access to Excel 2007

  • February 8, 2009 at 5:11 am

    #940136

    Try the following snippet....

    SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=d:\dasdgigs.xls', 'SELECT * FROM [dasdgigs$]')

    --Ramesh