Microsoft Office Tutorials and References
In Depth Information
AC 222
Access Integration Feature Sharing Data Among Applications
2
Click the Excel
button in the
Export group on the
External Data tab
to display the
Export – Excel
Spreadsheet
dialog box.
Export - Excel
Spreadsheet dialog box
location of
workbook to be
created
name of workbook
to be created
selected fi le format
(Excel Workbook)
Click the Browse
button and select
your USB fl ash drive
as the fi le location.
click arrow if you
want to change
fi le format
Browse button
Be sure the fi le name
is Recruiter-Client
Query and then click
the Save button
(Figure 15).
check box to
include formatting
and layout
Did I need to
browse?
No. You could type
the appropriate fi le
location.
check box
to open
destination fi le
after export is
complete
check box to only export
selected records (only valid
if you have selected records
prior to the export operation)
OK button
Could I change the
name of the fi le?
You could change
it. Simply replace
the current fi le
name with the one
you want.
What if the fi le
I want to export
already exists?
Access will indicate that the fi le already exists and ask if you want to replace it. If you click the Yes button, the fi le you
export will replace the old fi le. If you click the No button, you must either change the name of the export fi le or cancel
the process.
Figure 15
Search JabSto ::




Custom Search