Can anyone help me understand why the first SELECT statement doesn't
work, but the second one does:

Select * from [Sheet1$A1:A1] - This returns an empty recordset

Select * from [Sheet1$] - This works correctly

Sheet1 looks like this:

ID Package Department StartFrom
4 Budget A 1
5 Forecast B 1
6 Periodic Forecast C 1
7 NY Forecast D 1
8 NY_BUD E 1
9 CY_BUD F 1

I thought $A1:A1 meant get all used columns and rows, am I wrong?