CopyFromRecordset method

G

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
 
G

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
;)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top