Home › SQL Server › SQL Server OPENDATASOURCE

SQL Server - Reading information from an EXCEL file using OPENDATASOURCE


Reading information from an EXCEL file using OPENDATASOURCE

-- File Name: c:\data.xls
-- Worksheet Name: Sheet1
SELECT * 
FROM OPENDATASOURCE(
    'Microsoft.Jet.OLEDB.4.0',
    'Data Source=C:\data.xls;Extended Properties=EXCEL 5.0'
)...[Sheet1$];

Share |
 Cant find the page you are looking for?
 Help us to improve by adding the content that you are looking for.
 Leave a feedback
 We look forward to hear your comments and feedback.
  • 7351 reads