Microsoft Office Tutorials and References
In Depth Information
Importing from an Access desktop database
Import an Access database
7 Select the tables to import, or click Select All.
8 Click Options to display further options when importing data.
9 Choose to import or exclude the relationships.
10 Choose to import either definitions only or definitions and data.
11 Click OK. During the import process, your existing relationships will
be converted into Lookup data types.
12 Right-click the table that has relationships to other tables, and
select Edit Table.
The relationship is now shown as a Lookup data type.
13 Close the table.
CAUTIon Data types such as Attachments or OLE Objects are
not supported in a Web App and will be excluded from the