Microsoft Office Tutorials and References
In Depth Information
The relationship detection occurs only when you load data directly from more than one
table. When you load a single table or a query (which we discuss later), no relationship
detection takes place.
At the end of the list of Work Items in Table Import Wizard, shown in Figure 5-7, you can see
an additional step, called Data Preparation, which indicates that relationship detection has
FIguRE 5-7 The data preparation step of the Table Import Wizard.
If you want to see more details about the relationships that the Table Import Wizard
found, you can use the Details hyperlink to open a small window that summarizes the