Create excel spreadsheet from recordset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PeterW - 15 Apr 2006 09:39 GMT

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

Reply to this Message

Bob Quintal - 15 Apr 2006 13:26 GMT

> Hello.
>
[quoted text clipped - 8 lines]
>
> PeterW

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.

Signature

Bob Quintal

PA is y I've altered my email address.

Reply to this Message

PeterW - 15 Apr 2006 14:30 GMT

Just what I was looking for.

Many thanks.

Peterw

Reply to this Message

PC D - 15 Apr 2006 14:39 GMT

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.

>> Hello.
>>
[quoted text clipped - 14 lines]
>
> Note to PCD: Don't go away mad, just go away.

Reply to this Message

tommaso.gastaldi@uniroma1.it - 15 Apr 2006 18:40 GMT

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/archive/2005/06/27/433152.aspx

-tom

Reply to this Message