Home

Jump to bottom

KohrAhr edited this page Jul 20, 2019 · 8 revisions

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:

.Net framework 4.5.2
Microsoft ACE.OLEDB provider, version 12.0...16.0 is required.