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

exporting a report to excel

100+
P: 107
Hello,
When I export a report in access to excel - it doesn't show the field names the way I have them on the report- it shows the table names how they actually are.
Is there anyway to get them to excel with names on the report. I know I can put in snapshot form - but I cannot manipulate data then.
Or if there is no way is there any other programs that I might be able to export into and manipulate data.
Thanks
Apr 18 '08 #1
Share this Question
Share on Google+
4 Replies


100+
P: 107
Since no one replied yet - Excel must not be able to export report with field names on report.
I don't know of a way to delete this question- so I apoligize for probaly a not so intelligent question.
Apr 21 '08 #2

NeoPa
Expert Mod 15k+
P: 31,308
You don't say what you're currently using.

I would consider doing a TransferSpreadsheet of the query or table the report is run from.

Remember, a report is not designed to hold manipulable data - it's designed to show that data in as friendly a way as possible.

Does this make sense?
Apr 21 '08 #3

100+
P: 107
You are right.
I have access database with reports was exporting out to excel.
thank you
Apr 29 '08 #4

100+
P: 553
Hi

Reports can be output to Excel with "OutputTo" Action.

With regards to your question on change of data formatting in Excel, this article might be of any help:

How Reports are Output to Ms Excel

Regards
Qi
Apr 29 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.