>Cetin
>...
>
>limit to range, IOW the count of rows available in the range (or to end of sheet) is smaller then the number of records. How do I code the SQL select in Execute?
>
>I read your solution of empty dates - this one was incorporated instantly. ::)
>
>On your code you enter a path into ConnectionString. The other example uses a DBC. Thats what I'm wondering
>
>Agnes
The count depends on what you do. If it is a pivot table then probably you wouldn't need any limitation. If rows woudl be over then sheet limit then you could use sql top N.
A path or dbc works in connection strings (free tables you specify the folder - you could do that for database tables but specifying DBC is better IMHO).
Cetin