Is CopyFromRecordset a bug of Excel?

[sunzhoujian]

Here is the code piece...

With ThisWorkbook.Sheets("XX XX")
..Range(.Cells(4, 2), .Cells(intMaxRow + 3, _
intMaxCol + 1)).CopyFromRecordset rs
End With


Does anyone have experience of using CopyFromRecordset? I used it to
copy data from Access to Excel Worksheet. However, all those data
(with numerical ) are being changed to date. I have to mannually
format those cells before they can display correct. Thanks so much in
advance if you know what is the problem...

 

[Dave Trindall]

I'm having a similar issue, except for me it's numbers in the PREVIOUSLY active worksheet that are being formatted to dates.

I'm using Excel 2007.



sunzhoujia wrote:

Is CopyFromRecordset a bug of Excel?
02-Aug-07

Here is the code piece..

With ThisWorkbook.Sheets("XX XX"
..Range(.Cells(4, 2), .Cells(intMaxRow + 3,
intMaxCol + 1)).CopyFromRecordset r
End Wit

Does anyone have experience of using CopyFromRecordset? I used it t
copy data from Access to Excel Worksheet. However, all those dat
(with numerical ) are being changed to date. I have to mannuall
format those cells before they can display correct. Thanks so much i
advance if you know what is the problem...

Previous Posts In This Thread:

Is CopyFromRecordset a bug of Excel?
Here is the code piece..

With ThisWorkbook.Sheets("XX XX"
..Range(.Cells(4, 2), .Cells(intMaxRow + 3,
intMaxCol + 1)).CopyFromRecordset r
End Wit

Does anyone have experience of using CopyFromRecordset? I used it t
copy data from Access to Excel Worksheet. However, all those dat
(with numerical ) are being changed to date. I have to mannuall
format those cells before they can display correct. Thanks so much i
advance if you know what is the problem...

EggHeadCafe - Software Developer Portal of Choice
..NET 2.0 Application Restart When it Goes "KABOOM"
http://www.eggheadcafe.com/tutorial...6c0-abf68699dcd7/net-20-application-rest.aspx

 

[joel]

The problem isn't with copyfromrecordset. the problem is a general
issue with excel. Excel automatically updates data while the data is
placed in the worksheet. The problem occurs more often when a cell is
formated as general then other formats. Excel isn't looking at the
format of hte database.

You will see a similar problem in VBA depending if you use and equal
sign to put data into the worksheet verses using copy. the copy method
will copy the formating of the source cell to the destination cell but
using an equal sign will use the destination format.