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

Acces report to excel

P: n/a
Hi folks,
I have a report in acess and I will like to exported the report data
into an excel pre-denied cells.
Does anyone knows I can I do that.

Any suggestions will be appreciated.
Thank you to all,
Fred's.

Feb 20 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I am not sure what predenied cells are, but if you can describe the
objective you are attemping to satisfy rather than a partial
methodology of how it may be accomplished, perhaps I can help.
Normally to send data to excel one would create a query containing the
desired data and then call the DoCmd.TransferSpreadsheet function.

On Feb 20, 12:04 pm, "Fred's" <frederic10_m...@hotmail.comwrote:
Hi folks,

I have a report in acess and I will like to exported the report data
into an excel pre-denied cells.
Does anyone knows I can I do that.

Any suggestions will be appreciated.
Thank you to all,
Fred's.

Feb 20 '07 #2

P: n/a
On Feb 21, 4:04 am, "Fred's" <frederic10_m...@hotmail.comwrote:
Hi folks,

I have a report in acess and I will like to exported the report data
into an excel pre-denied cells.
Does anyone knows I can I do that.

Any suggestions will be appreciated.
Thank you to all,
Fred's.
I've done this a few ways.

One is automation where you use Vba to manipulate the worksheet from
MS Access.
The one I've settled on is DDE to call VBA within the Worksheet to
grad the data.

Keith

Feb 20 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.