Ron wrote:

Sometimes, the first
cell in the last row of the worksheet returns a blank, even though
there is definately data in the cell - a number that I am
converting to a long format. The conversion fails because
the program sees an empty string ("").

Usually when a cell containing data is read as null when reading via
Jet, the cause is a mixed data types situation e.g. the data type for
the column has been determined by Jet as 'numeric' and any cells
containing 'text' values are nulled. For details, see:

http://www.dicks-blog.com/archives/2...ed-data-types/
Jamie.

--