Exporting Information to Another Access Database


It is very simple to export any single object from one Access 2007 database to either another Access 2007 database or to an Access 2003 database. You can't, however, export multiple objects in one operation.

Tip

Data types that are new in Access 2007, such as Attachment or Rich Text, will not export properly to Access 2003. Rich text is exported as tagged HTML, and attachments are exported as the filename of the attachment.


In this exercise, you will export a table from one Access database to another.

USE the 01_ExportAccess and 01_Exported databases. These practice files are located in the Chapter04 subfolder under SBS_Access2007.

BE SURE TO start Access before beginning this exercise.

OPEN the 01_ExportAccess database.


1.

In the Navigation Pane, under Tables, click Suppliers.

Because you will export the entire table, there is no need to open it first. You only need to select it in the Navigation Pane.

2.

On the External Data tab, in the Export group, click the More button, and then in the list, click Access Database.

3.

In the Export Access Database wizard, click the Browse button.

4.

In the File Save dialog box, navigate to the Documents\MSP\SBS_Access2007\Chapter04 folder, click 01_Exported.accdb, and then click Save.

5.

In the Export Access Database wizard, click OK.

The Export dialog box opens.

6.

In the Export dialog box, with Suppliers showing in the Export Suppliers to: box and Definition and Data selected under Export Tables, click OK.

Access exports the selected table.

7.

In the Save Export Steps dialog box, click Close.

Tip

You can open only one database at a time in a single instance of Access. If you open a second database without first closing the one you are working in, Access prompts you to save recent changes and then closes the first database before opening the second. To open two databases at the same time, launch a second instance of Access from the Start menu, and then open the second database from the File menu; or launch Access and open the database by double-clicking the database file in Windows.

8.

In Windows Explorer, navigate to the Documents\MSP\SBS_Access2007\Chapter04 folder and double-click 01_Exported.accdb.

The 01_Exported database opens in a separate instance of Access 2007.

9.

In the Navigation Pane, under Tables, double-click Suppliers and verify that the table exported correctly, then close this instance of Access.

CLOSE the 01_ExportAccess database.




MicrosoftR Office AccessT 2007 Step by Step
MicrosoftR Office AccessT 2007 Step by Step
ISBN: N/A
EAN: N/A
Year: 2004
Pages: 127

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net