View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] HB_temp@aapt.net.au is offline
external usenet poster
 
Posts: 3
Default rows.count property returns 2 even though only 1 row was importedby querytables.add

This is typical when the process writing the data to the text file doesn't
deliberately exclude the last carriage-return/linefeed. So importing as you've
done will include a blank record causing the record count to inflate by 1!


Garry,

Thanks but the inflation-by-one only occurs if the file has just one line, with or without the CR/LF (as created by venerable Notepad); with 2 or more lines, Rows.count returns the expected result.

Strangely, for a zero-length file it throws error 7 "out of memory" when zero is surely the expected result.