Reading Excel data using SQL
Someone was asking what is the fastest way to determine the number of lines in an Excel sheet.
Fast reading the number of records in Excel
Well the best way for speed is SQL of course, opposed to the EXCEL COM fucntions.
Here's is how to get stared :
Const $adOpenStatic = 3
Const $adLockOptimistic = 3
Const $adCmdText = 0x0001
Global $s_Tablename = "[Sheet1$]"
; Initialize COM error handler