Geoff,
take a look at this

Re: Accessing Excel Sheet Thread #703274 Message #703291
>Hi
>
>I'm sure I've asked this before but I cant seem to find it.
>
>How do I determine how many rows (what the data area) is in an excel spreadsheet.
>
>regards
>Geoff Scott