CONTENTS OF THIS PAGE

• EXPORTING YOUR DATA TO MICROSOFT ACCESS
• CONFIGURATION OPTIONS (button not explained in the help page)
• VIEWING YOUR UPS TRACKING NUMBER

BUTTON HELP - Explanation of each button; consult this help page to learn the functionality of each button in the grid header.

   EXPORTING YOUR DATA

Currently, downloading your database into Microsoft Access will require an additional step. You will need to save your displayed grid in Excel, HTML or XML format. Once the file is saved to your hard drive, you can import that file into Access. Importing capabilities may be limited based on your version of Microsoft Access.

IMPORTING INTO ACCESS

1) Save the data file.

• Excel - Once the SAVE button is clicked, you will be prompted to Open, Save or Cancel the Excel file. Click Save.
• HTML & XML - Once the SAVE button is clicked, a new internet browser window will be displayed. Click File then Save As...

...Select the location to you wish to save the file and specify the name of the file, then click Save. It is recommended to save the file to "My Documents" or "Desktop" to make it easy for you to locate the file when you attempt to import it into Access.

2) Import

1. Open Microsoft Access.
2. Create a new blank database.
3. Click File --> Get External Data --> Import
4. Navigate to the directory in which your data file is saved.
5. Select the valid file type from the drop down list at the foot of the Import form.
6. Select the applicable file in the file list.
7. Click the Import button.
   1. Excel & HTML Import Wizard
      1. Ensure "First Row Contains Column Headings" box is checked then click Next.
      2. The remainder of the import wizard options will be tailored to your needs.
   2. XML Import
      1. There are less options and user intervention with this method than Excel or HTML.
      2. Click the Options button to specify if you wish to "Append Data to Existing Table(s)".
      3. Click OK

NOTE: Exporting using XML is the preferred method for beginner Microsoft Access users.

NOTE: Data importing availablity and procedures may vary due to your version of Microsoft Access. Some versions of Access require you to open and save your downloaded Excel file before importing the data to Access.

   CONFIGURATION OPTIONS

• Page Size - Default is 100. You can specify the number of rows to display on the grid.
• Print Type - Default is Enhanced.
• Save Type - Default is Standard.
• Copy Type - Default is Enhanced.
• Filter Type - Refers to drop-down search criteria boxes below the column headers in the grid.
  • Simple (default) - Populates the box values based on distinct data of a given field within the entire database.
  • Composite - Populates the box values based on distinct data of a given field within the displayed grid.

VIEWING YOUR UPS TRACKING NUMBER

You can view the status of each package that is sent from our facility via UPS. Simply click on the tracking number of the shipment you wish to view. A new internet browser window will be opened and will connect to UPS's website. The tracking number you clicked will automatically be displayed in the browser without any extra typing or navigation.