SQL query using ADO, but the query is not pulling all the data

[JieJenn]

Update: Problem Fixed. Didn't realize ADO only supports up to MS office 2003.

Having this really weird problem that I couldn't figure out. I create a SQL userform where a user can just enter SQL query in Excel directly. But for some reason when I do a SELECT * statement it is not pulling all the data from the excel worksheet.

Basically, my code is treating Excel workbook like a MS Access database, each worksheet is like a "table". Here is where my problem comes. In RawData worksheet, I have a total # of items of 110,380, but when I do a SELECT * FROM [RawData$] statement, the result only gives me 44,844 items rather than 110,380 the entire population.

I have my work in process and the code below. Would really appreciate if anyone can guide me to figure out what caused the issue.

Thanks,

PS: You can open the UserForm by Right click your mouse and select SQL Query shortcut.