CopyFromRecordset method
 

Hi all,

I use vb6+excel 2k3 + adodb.
I am trying to fill an excel sheet with data from a recordset, by using
CopyFromRecordset.

My problem is that the RS contains a date formatted like date + time and in
the excel sheet I see only the date part :(

Please advise!!
TIA
Guy

CopyFromRecordset method
 

Hi

I tried to format (dd/mm/yyyy hh:mm:ss) the columns after filling the data
and it is ok now...

HTH
Guy
;)


"Guy Cohen" wrote:

Hi all,

I use vb6+excel 2k3 + adodb.
I am trying to fill an excel sheet with data from a recordset, by using
CopyFromRecordset.

My problem is that the RS contains a date formatted like date + time and in
the excel sheet I see only the date part :(

Please advise!!
TIA
Guy