By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,092 Members | 1,597 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,092 IT Pros & Developers. It's quick & easy.

Create excel spreadsheet from recordset

P: n/a
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
Apr 15 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"PeterW" <pw****@btinternet.com> wrote in
news:ZM********************@bt.com:
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

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.
Apr 15 '06 #2

P: n/a
Just what I was looking for.

Many thanks.
Peterw
Apr 15 '06 #3

P: n/a
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" <rq******@sympatico.ca> wrote in message
news:Xn**********************@207.35.177.135...
"PeterW" <pw****@btinternet.com> wrote in
news:ZM********************@bt.com:
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

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.

Apr 15 '06 #4

P: n/a
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

Apr 15 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.