Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |