To an “Excel” file

You have the option of exporting a “Table”, a select “Query” or crosstab “Query” to an “Excel” file.

To do this, select the object in the “Navigation pane” and click the “Export to Excel worksheet” button under the “External Data” tab in the “Ribbon”.

This opens the “Export” dialog.

In the first box, you determine where you want to save the file.
Click the “Browse” button and navigate in the window to the location on your computer where you want to save the file.
In the second box, you determine the file format in which you want to save the file, by default this is set to an “Excel” 2007 file (.xlsx), but you can change it to an earlier version of “Excel” by clicking the downward pointing arrow button.

You can choose the data layout and format to export.
You do not have to select the first option, but when you do, the second option is available.

The third option is available only when the object is opened and when records are selected in this object.

Click the OK button when you’re done.

In the next window that appears, you have the option to save the export steps for later use.
Click the “Close” button.
The object that you had selected in the “Navigation pane” is now saved as an “Excel” file.
 

To a “Word” file

We also have the option of exporting a “Table”, a select “Query” or crosstab “Query” to a “Word” document.

To do this, select the object in the “Navigation pane” and click the “Word” button under the “External Data” tab in the “Ribbon”.

And follow the same steps that you have seen in the “Export to Excel worksheet”.

Export from one object to another database

You can copy any object from one database to another database.

To do this, select the object in the “Navigation pane” and click the “More” button in the “Ribbon”.

From the drop-down menu, choose the first option “Access database”.

In the first window that appears, click the “Browse” button to navigate to the database where you want to add the object .

And click the OK button.

In the next window that appears, give the object a name.

Determine whether you want just the definition (structure) of the table to export, or the definition and data also.

Click the OK button.

In the last window, there you are again asked if you want to save the export steps.
Click the “Close” button.

When we open the database, you will see that the newly exported table (customers) is added in the “Navigation panel”.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats