Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CopyFromRecordset Problem
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format data in Excel after using copyfromrecordset | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |