Q: Using CopyFromRecordset to populate Excel spreadsheet

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi,

I'm sending a recordset to an Excel spreadsheet using the
CopyFromRecordset method. I get that to work, but I need
to copy the recordset as text. Is there a good way to do
this?

Thanks,
-Mark
 
I'm sending a recordset to an Excel spreadsheet using the
CopyFromRecordset method. I get that to work, but I need
to copy the recordset as text. Is there a good way to do
this?
Click to expand...

I don't think CopyFromRecordset allows for this. YOu can copy a cell and do
a PasteSpecial from code over a given range to convert the numbers to text.

-- Dev
 
Thanks Dev,

I ended up recording a macro in excel, selecting the range
and changing that range to text, then copying the code
generated into the Access code. Outside of a few tweaks,
it worked pretty well.

-Mark
 
Back
Top