CopyFromRecordset method

[Guy Cohen]

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

 

[Guy Cohen]

Hi

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

HTH
Guy