Problem with CopyFromRecrodset
 

Can't say why this could happen without seeing the code - especially the SQL
query text. Is there any pattern or distinctive characteristic about the
records that are missing? Are they from the end of the recordset, or
scattered throughout?

--
- K Dales


"Mr B" wrote:

I am attempting to get a recordset from MSAccess into a spreadsheet by
executing a query through the use of ADO and then using the CopyFromRecrodset
process to get the data to the spreadsheet.

All works through code as expected to product the spreadsheet with data in
it. However, the problem is that the spreadsheet does not have the same
record count as is returned by running the same query directly from Access.
When run from Access the query returns 6166 recrods. When the spreadsheet is
created there are only 5675 rows created.

Any ideas would be appreciated.

--
HTH

Mr B