| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot use recordset twice with copy From recordset
try adding RS05.MoveFirst I'm not sure why the code ever worked. Not sure if you are opening and closing the recordset. A recordset is similar to a file which moves the pointer as it move the data so when you done reading everything the point is at the end of the file and you have to reset the pointer to the beginning of the file before you can read the data a 2nd time. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=176179 Microsoft Office Help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from recordset errors in ADO | Excel Programming | |||
| Copy an array into an ADO recordset? | Excel Programming | |||
| Copy From Recordset | Excel Programming | |||
| Type recordset/recordset? | Excel Programming | |||
| Copy Recordset into array? | Excel Programming | |||
![joel[_639_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
