Microsoft Office Tutorials and References
In Depth Information
To use the Table Analyzer to analyze the imported table:
1. Click the Yes button to close the dialog box and to open the first Table Analyzer
Wizard dialog box. The diagram and explanation in this dialog box describe the
problem when duplicate data is stored in a table.
2. Click the first Show me an example button , read the explanation, close the
example box, click the second Show me an example button , read the explana-
tion, close the example box, and then click the Next button to open the second
Table Analyzer Wizard dialog box. The diagram and explanation in this dialog box
describe how the Table Analyzer solves the duplicate data problem.
3. Click the first Show me an example button , read the explanation, close the
example box, click the second Show me an example button , read the explana-
tion, close the example box, and then click the Next button to open the third Table
Analyzer Wizard dialog box. In this dialog box, you choose whether to let the wiz-
ard decide which fields go in what tables, if the table is not already normalized.
You’ll let the wizard decide.
4. Make sure the Yes, let the wizard decide option button is selected, and then
click the Next button. A message box informs you that the wizard does not recom-
mend splitting the table because the table is normalized and does not contain
redundant data.
5. Click the Cancel button to close the message box, exit the wizard, and return to
the Get External Data - Text File dialog box, in which you are asked if you want to
save the import steps. You don’t need to save these steps because you’re importing
the data only this one time.
6. Click the Close button to close the dialog box.
Tip
You can start the Table
Analyzer directly by click-
ing the Database Tools tab,
and then clicking the Ana-
lyze Table button in the
Analyze group.
The TblCustomerBilling table is now listed in the Tables section in the Navigation
Pane. You’ll rename the table to change the initial letter to lowercase, and then open the
table to verify the import results.
To rename and open the imported TblCustomerBilling table:
1. Right-click TblCustomerBilling in the Navigation Pane, click Rename , press the
Home key, press the Delete key, type the letter t , and then press the Enter key to
change the table name to tblCustomerBilling.
2. Double-click tblCustomerBilling in the Navigation Pane to open the table
datasheet, resize all columns to their best fit, and then click 11020 in the first row
in the CustomerID column to deselect all values. See Figure 8-7.
Imported tblCustomerBilling table datasheet
Figure 8-7
3. Save and close the table.
Sarah has some additional data that she wants to import into the Panorama database.
The data is stored in XML format.
Search JabSto ::




Custom Search