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?

A1:A1 refers to a range starting in cell A1 and ending in cell A1, so you are
collecting data from only that cell.
Sheet1 refers to the entire sheet, so you are collecting data from all cells.
GS

" wrote:

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?