Back to Index |

Excel - selecting a range of cells

When selecting data from an Excel sheet, you can also specify a range of cells to read. To do this, simply include the cell range in the SQL statement. For example, if you wanted to read cells A1 through M100 on Sheet1, you would enter the SQL Statement in the following way:

SELECT * FROM [Sheet1$A1:M100]

© 2003 - 2007 Relational Solutions, Inc. - All rights reserved