Create excel spreadsheet from recordset

Hello.

Is it possible, using code, to create a spreadsheet in excel format, with
cells containing constant text and formulae and inserting data from a
recordset in specific cells?

If so, could someone point me to an information page with details on how to
achieve this?

Many thanks

PeterW

re: Create excel spreadsheet from recordset

"PeterW" <pwooly@btinternet.com> wrote in
news:ZMadnV0diPeyLN3ZRVny1w@bt.com:
[color=blue]
> Hello.
>
> Is it possible, using code, to create a spreadsheet in excel
> format, with cells containing constant text and formulae and
> inserting data from a recordset in specific cells?
>
> If so, could someone point me to an information page with
> details on how to achieve this?
>
> Many thanks
>
> PeterW
>[/color]
start with these:
http://www.mvps.org/access/modules/mdl0006.htm
http://www.mvps.org/access/modules/mdl0035.htm


Note to PCD: Don't go away mad, just go away.
--
Bob Quintal

PA is y I've altered my email address.

re: Create excel spreadsheet from recordset

Just what I was looking for.

Many thanks.


Peterw

re: Create excel spreadsheet from recordset

I am SURPRISED!!!

You did not recommend your procedure to export records to Excel that takes
hours to run!!! Since ot works, you said that it is the correct way to do
it.


"Bob Quintal" <rquintal@sympatico.ca> wrote in message
news:Xns97A655D1E4984BQuintal@207.35.177.135...[color=blue]
> "PeterW" <pwooly@btinternet.com> wrote in
> news:ZMadnV0diPeyLN3ZRVny1w@bt.com:
>[color=green]
>> Hello.
>>
>> Is it possible, using code, to create a spreadsheet in excel
>> format, with cells containing constant text and formulae and
>> inserting data from a recordset in specific cells?
>>
>> If so, could someone point me to an information page with
>> details on how to achieve this?
>>
>> Many thanks
>>
>> PeterW
>>[/color]
> start with these:
> http://www.mvps.org/access/modules/mdl0006.htm
> http://www.mvps.org/access/modules/mdl0035.htm
>
>
> Note to PCD: Don't go away mad, just go away.
> --
> Bob Quintal
>
> PA is y I've altered my email address.[/color]

re: Create excel spreadsheet from recordset

I would use ole autom only for occasional work and small dataset (every
time I tried it took ages, especially if you have complex cell
formatting).

I would rather look for XML

for instance (there are several refs on the web):
http://blogs.msdn.com/brian_jones/ar...27/433152.aspx

-tom