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

Exporting to MS Excel

P: n/a
I would like to export a result of query to Excel sheet. Mayby somebody
from you know how to do this?

Thanks
Wojciech Wasikiewicz
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
In article <bt**********@korweta.task.gda.pl>, "wojtekW" <wo******@op.pl>
writes:
I would like to export a result of query to Excel sheet. Mayby somebody
from you know how to do this?

Thanks
Wojciech Wasikiewicz


If the query can simply go into Excel "as is" with no special formatting then
you can use DoCmd.TransferSpreadsheet. Otherwise, you will need to use
automation to "push" the data into Excel.
--

Jon

www.applecore99.com - Access Tips and Tricks

Nov 12 '05 #2

P: n/a
In Access 97 and XP you can use the File --> Export command. In 97 it
says something like Save As/Export. It opens the common dialog, you
navigate to the place you want the Excel file, name it, and click
Export. If you want to keep the query formatting (column widths and
such) make sure the Save Formatting box is checked before you export.

js********@aol.com (JSand42737) wrote in message news:<20***************************@mb-m22.aol.com>...
In article <bt**********@korweta.task.gda.pl>, "wojtekW" <wo******@op.pl>
writes:
I would like to export a result of query to Excel sheet. Mayby somebody
from you know how to do this?

Thanks
Wojciech Wasikiewicz


If the query can simply go into Excel "as is" with no special formatting then
you can use DoCmd.TransferSpreadsheet. Otherwise, you will need to use
automation to "push" the data into Excel.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.