|
Home > Archive > MS Access Database with External Data > September 2005 > Exporting bunch of data to Excel
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Exporting bunch of data to Excel
|
|
| Mauricio Silva 2005-09-29, 9:24 am |
| Hi guys,
I was wondering. Is there a way to export a bunch of data to Excel at once.
I mean, since I create my reports with specific format and formulas, I don't
just use the TransferSpreadsheet,
I am exporting data cell by cell,
formating, verifying, skiping lines... but this takes a very long time. Is
there a command or something like:
xlsSheet.Range ("A1:A10") = ListOfData ?
Thanks a bunch
Mauricio Silva
| |
| Klatuu 2005-09-29, 11:24 am |
| I think the CopyRecordSetFrom method of the Range object will do what you want.
"Mauricio Silva" wrote:
> Hi guys,
>
> I was wondering. Is there a way to export a bunch of data to Excel at once.
> I mean, since I create my reports with specific format and formulas, I don't
> just use the TransferSpreadsheet,
I am exporting data cell by cell,
> formating, verifying, skiping lines... but this takes a very long time. Is
> there a command or something like:
> xlsSheet.Range ("A1:A10") = ListOfData ?
>
> Thanks a bunch
> Mauricio Silva
|
|
|
|
|