| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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 |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
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 > > |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Method 'CopyFromRecordset' error | Vsn | Microsoft Access Form Coding | 4 | 16th Nov 2009 03:52 AM |
| Error 430 problem when using CopyFromRecordset method (cont'd) | =?Utf-8?B?TWFyaw==?= | Microsoft Access | 6 | 15th Aug 2006 04:32 AM |
| Error 430 using .CopyFromRecordset method | =?Utf-8?B?TWFyaw==?= | Microsoft Access | 2 | 16th Aug 2005 05:21 PM |
| CopyFromRecordset method | poppy | Microsoft Excel Programming | 0 | 28th Sep 2004 09:49 AM |
| Re: CopyFromRecordset method | poppy | Microsoft Excel Programming | 0 | 8th Sep 2004 07:10 AM |
