• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 18. Sharing Data with Other Applica... > Exporting to Another Access Database

Exporting to Another Access Database

You can easily export Access tables and queries to another Access database. The following is the required process:

1.
Right-click the object you want to export and select Export from the context menu. The Export Table dialog box appears.

2.
Select the Access database to which you want to export the object and then select Export. The Export dialog box appears (see Figure 18.1).

Figure 18.1. The Export dialog box, which allows you to designate the destination table.


3.
In the Export dialog box, select Definition and Data or Definition Only, depending on whether you want to export just the structure or the structure and the data. Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint