O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Exporting to Another Access Database

Exporting objects from one Access database to another works much like importing Access objects. (See Chapter 8, for details.) To export any object from one Access database to another Access database, do the following:

  1. Open the Access database from which you want to export an object.

  2. Select the object you want to export in the Navigation pane. On the External Data tab, in the Export group, click the Access command. Access opens the Export – Access Database dialog box. Click Browse, and then select the folder and the name of the desktop database (.accdb) or project file (.adp) to which you want to export the object. (You can export queries in an Access project only to another project file.) After you make these ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required