Incorrect RecordCount when opened a Excel sheet in ADO Recordset

Incorrect RecordCount when opened a Excel sheet in ADO Recordset

Post by Tom Ogilv » Thu, 23 Jun 2005 22:17:43


You probably need to go into the sheet and manually delete all the rows
below the header row (entire rows, not cells). then save the workbook. If
you then do Edit=>goto special and select last cell, it will take you to the
last filled cell on the header row (if not, you didn't do it right). Then
you should get the proper count I would think.

--
Regards,
Tom Ogilvy