
March 1st, 2005, 08:04 AM
|
|
Registered User
|
|
Join Date: Mar 2005
Posts: 10
Time spent in forums: 4 h 55 m 59 sec
Reputation Power: 0
|
|
|
Select range of excel cells in flexgrid
I've connected an excel spreadsheet to a flexgrid but don't know the sql syntax to select a specific range of cells.
I know I can use SELECT * FROM [Sheet1$] but I need to limit the range further, ideally selecting the first four columns and tjhe full range of rows that contain data (the number of rows will increase as the spreadsheet expands).
Any help is much appreciated.
|