Search results

I have an ADO recordset "adoDataset", retreived from the web. I also have a listbox "lstDataset" in a form. I need to populate lstDataset with only the 2nd, 3rd and 5th fields of adoDataset. Is there an efficient way? One which doesn't involve iterating over the records of the set and adding the...

Hi Trying to dump a table into Excel using CopyFromRecordset, but it's only copying the first dozen rows, then breaking halfway through the next with the error message "Run-time error '-2147467259 (80004005)' Method 'CopyFromRecordset' of object 'Range' failed", which doesn't really tell me...

Thanks Geoff - didn't fix the problem but your suggestion is appreciated. It seems to be a problem with the CopyFromRecordset method in the DAO library, as the field in the recordset at runtime holds the full text, it's just when it's dumped into Excel that it's truncated. Not ideal, but at...

Hi all I've posted this in my usual Excel forum without any response so I figure someone here might be able to help. I'm using an SQL query in an Excel VBA macro to extract info from an Access table and dump it into an Excel worksheet, which works fine except for a Memo field, which is...