Excel sheet to DataGrid (using ADO.NET)

Question

Getting a named range in excel to a DataGrid is no problem but when I try to put a whole sheet into the grid nothing seems to work. I've tried "SELECT Sheet1.* FROM Sheet1", "SELECT * FROM Sheet1", "SELECT * FROM Sheet1$" etc etc I've used the Microsoft Jet 4.0 OLEDB Provider with Extended Properties set to HDR=Yes (tried No too) and IMEX=2 (and 1) Is a named range the only way to do this? (I don't want to use Interop)