Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Similar problem
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 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... Previous Posts In This Thread: On Thursday, August 02, 2007 11:56 PM sunzhoujia wrote: 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 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... EggHeadCafe - Software Developer Portal of Choice ..NET 2.0 Application Restart When it Goes "KABOOM" http://www.eggheadcafe.com/tutorials...tion-rest.aspx |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Similar problem
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. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149668 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format data in Excel after using copyfromrecordset | Excel Discussion (Misc queries) | |||
MFC - CopyFromRecordset - Copy data to Excel | Excel Programming | |||
copyfromrecordset fails after upgrade to XP and Excel 2003 | Excel Programming | |||
Excel VBA - CopyFromRecordset (ADO) Problems with 107000 records | Excel Programming | |||
Excel 2003 - 'CopyFromRecordset' Error | Excel Programming |