Problems Using .DBF Files in Microsoft Query

• Microsoft Query for the Macintosh, version 1.0
• Microsoft Excel for the Macintosh, version 5.0

SYMPTOMS

In Microsoft Query, when you use a .DBF file created in Microsoft Excel, one of the following symptoms occurs:

• You do not see any of the Microsoft Excel files in the Add Table dialog box.

      -or-
  

• You receive the following error message when you attempt to add the table to a query

        Can't access table <path\file name>
  

  where <path\file name> is the full path and file name of the table you are adding.

   ARTICLE-ID: Q107835
   TITLE     : Query: Microsoft Query Error Message "Cannot Access Table"

CAUSE

The first symptom occurs if the FoxPro ODBC driver does not have custom file types entered.

The second symptom occurs if the table file name does not end with a .DBF extension.

WORKAROUNDS

To configure a data source to show and use .DBF files created in Microsoft Excel, do the following:

1. From the Apple menu, choose Control Panels. Double-click the ODBC Setup icon.

2. Choose the Setup Data Sources button.

3. Choose the Add button to add a new data source, or select an existing FoxPro data source, and choose the Modify button.

4. If you are adding a new data source, select "Q+E/Microsoft FoxPro Driver," and then choose OK.

5. After you type a Data Source Name, choose the Mac File Info button, and enter the following information:

         File Creator:          XCEL
         Data Base File Type:   BINA
   
      NOTE: You must use uppercase letters for the names you type.
   
      You can leave the other items as they are, because Microsoft Excel
      doesn't create index files or memo files.
   
   

To avoid receiving the error message above when you save a file in DBF file format from Microsoft Excel, do the following:

1. Activate the worksheet in the workbook that contains the list that you want to save.

2. From the File menu, choose Save As. From the Save File As Type list, select DBF4 (DBASE IV).

3. Enter the desired file name, and be sure to use the .DBF file name extension. For example, name your file DATABASE.DBF.

MORE INFORMATION

For additional information concerning the use of dBASE files on the Macintosh, please see the following articles in the Microsoft Knowledge Base:

   ARTICLE-ID: Q140701
   TITLE     : "Microsoft Query May Open the Wrong DBF File"

   ARTICLE-ID: Q107835
   TITLE     : "Microsoft Query Error Message "Cannot Access Table"