Home

Welcome to the SqlOverExcel wiki!

Purpose:

• run SQL query (MS Access compatible) over MS Excel file

Allowed file types:

• XLSX -- Excel Workbook (..Office 2016)
• XLSM -- Excel Macro-Enabled Workbook
• XLSB -- Excel Binary Workbook
• XLS -- Excel 97-2003 Workbook

Requirements:

1. .Net framework 4.5.2
2. Microsoft ACE.OLEDB provider, version 12.0...16.0 is required. Download Microsoft Access Database Engine 2010 Redistributable from https://www.microsoft.com/en-us/download/details.aspx?id=13255 Download Microsoft Access Database Engine 2016 Redistributable from https://www.microsoft.com/en-us/download/details.aspx?id=54920