access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

Access

resolvedResolved · Low Priority · Version 2007

Geoff has attended:
Access Advanced course

Access

Can data be automatically exported to Excel e.g. after running a query

RE: Access

Hi Geoff

Thank you for your question

If you go to the querys section of the main access window and select the query you want to export, you can then simply export the query straingth into excel using the analyse with excel button on the main toolbar

Regards

Stephen


 

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips


Server loaded in 0.08 secs.