Forum home » Delegate support and help forum » Microsoft Access Training and help » Exporting to Excel
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Exporting to Excel
Resolved · Low Priority · Version 2003
Reply Fri 18 Jul 2008, 16:35Delegate Ben said...
Ben has attended:
Access Introduction course
Access Intermediate course
Exporting to Excel
When exporting to excel, will the decimal selection Eg "none" be transferred too?
For upcoming training course dates see: Pricing & availability
RE: Exporting to Excel
Dear Ben
Thank you for attending Access Courses. I hope you enjoyed the courses and have started to put the new learnt skills into practice.
Yes the data type along with the filed property gets exported into Excel.
The quickest way to exporting an Access Table or Query from Access to Excel is to open the table or simply select it in Database window and choose Tools > Office Links > Analyze it with MS Excel.
You can also export it directly to Word by choosing Tools > Office Links > Publish it in MS Word
If you are doing a mail merge and want the fields in a table to be merged then you can choose Merge it with MS Word.
I hope this has helped in answering your query. If this has answered your question then may I please request you to mark this post as resolved!!
Many thanks
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
|