Select the Customer_ID from the Customers table.
Select the Order_ID, Order_Date, Required_Date, and
Ship_Date from the Orders table. You should end up with
something similar to Figure 8.3.Figure 8.3 The query selection.
- After you have selected the fields, run the query. You can do this by clicking the
exclamation point on the toolbar. Your screen should look similar to Figure 8.4.
Figure 8.4 The query results.
- Save the query as OrdersImport. After you have saved the query, right-click
the query's name. A pop-up menu should appear. Scroll down to Export on the
menu and left-click. - You should now see the Export Query dialog box (see Figure 8.5). The filename
should default to the name of the query—OrdersImport. Underneath the
filename are your export choices. For now, choose the Text File option and click
the Save button.
Figure 8.5 The Export Query dialog box.
- The Export Text Wizard will automatically start (see Figure 8.6.). The Wizard
helps you format your file. Remember, you want a file where the fields are
separated by commas and text fields are enclosed by quotation marks. Make sure
the Delimited option is checked, and then click Next.