Part III: More-Advanced Access Techniques
628
FIGURE 17.21
The HTML Export dialog- Follow the next screens to select your HTML output options, as well as your VBA macro
export processing save options. Keep clicking until you finish.
The HTML export is completed as soon as you click the OK button. No options other
that what you see in Figure 17.21 are available when exporting HTML data.
Importing the HTML is simply the reverse of the export process.The fundamental difference between importing XML and HMTL files is based on the basic differ-
ence between HTML and XML. The HTML import process imports data in much the same way as
text files, using similar wizard options. XML, on the other hand, may include metadata and other
description information.Importing Access objects other than tables
You can import other Access database tables or any other object in another database, which means
you can import an existing table, query, form, report, macro, or module from another Access data-
base. You can also import custom toolbars and menus.As a simple demonstration, follow these steps:- Open the Chapter17_1.accdb database.
- Under the External Data tab, in the Import section, click the option to import from
another Access database.
The screen in Figure 17.22 appears. Notice that this dialog box enables you to specify
whether to import database objects or link to tables in an external Access database.