expression .CopyFromRecordset problem

[Spoulis19]

HOW to transfer data from five ms access table fields to an excel worksheet with copy from recordset method

But three access fields to be copied in excel range starting in cell a5, and the other two fields to be copied to excel range g5 and i5.

The problem is that copy from recordset method Copiesthe contents of an ADO or DAO Recordset object onto a worksheet,beginning at the upper-left corner of the specified range and i have to avoid insert columns due to other restrictions. Any ideas?

expression .CopyFromRecordset(Data,MaxRows, MaxColumns)<o></o>
expression A variablethat represents a Range object.<o></o>

 

[ukmikeb]

Hi

Try the GetRows method, description here :-
GetRows Method Example (VB)

where the record/s are put into an array and you can handle the array to manipulate storage of the required fields.

hth

 

[Spoulis19]

Thank you very much, this is the solution i was looking for...

Hi

Try the GetRows method, description here :-
GetRows Method Example (VB)

where the record/s are put into an array and you can handle the array to manipulate storage of the required fields.

hth

 

[ukmikeb]

Hi

Thanks for the feedback.

Pleased to have helped solve your problem.

Good luck with your project.