First of all, have a look here:
Quote:
Your first option is to specify a worksheet and, optionally, a set of cells on that sheet. You need to make sure that the worksheet name is followed by a dollar sign and then, optionally, a cell set. The cell set is specified by the starting cell and terminating cell of the set, separated by a colon. This whole data identification string is then enclosed in brackets. A SELECT statement using this type of syntax might look like this:
SELECT SalesMonth, TotalSales, PercentageChange1Year
FROM [Sheet1$A1:E24]
Source:
Accessing Microsoft Office Data from .NET Applications[
^]
Secondly, replace:
MyCommand = New OleDb.OleDbDataAdapter
with:
MyCommand = New OleDb.OleDbCommand