Browse by Tags

Query directly from Excel
14 January 09 05:30 PM | Ronen Chenn | with no comments

Hi, As you know there are always customers who want fast delivery NO MATTER WHAT. You can always query directly from the XLS source and by that bypass the ETL step. Please find the attached code for OPEN ROW SET. SELECT * FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database={FileLocation}', [Sheet1$]) Enjoyee Ronen

תגים:DEV, OPEN QUERY, EXCEL