Microsoft Office Tutorials and References
In Depth Information
Configure the Connection Information
After loading the sample workbook, press the Database button and select Access (Jet) in the
drop-down box at the top of the Database Properties window. (See Figure 24-6.) Then enter
the full path to the file containing the database and press OK.
Figure 24-6. Choose Access (Jet) in the drop-down box, and then enter the path in
Enter a Query
Next press the Edit Query button, enter the following query (shown in Figure 24-7), and
press the Close button.
Order By CustomerId
Figure 24-7. Enter the query you want to run.