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_Filename=FileGetShortName("C:TmpTest.xls") Global $s_Tablename = "[Sheet1$]" ; Initialize COM error handler $oMyEr