Knowledge Base |

# "Query Can't Be Represented" Using Paradox Table

Article ID: 124106

Article Last Modified on 8/15/2005

APPLIES TO

- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Query 2000

This article was previously published under Q124106

## SYMPTOMS

In Microsoft Query, if you create a query using a Paradox data source, and you edit the SQL command directly in the SQL dialog box, you receive the following error message:
SQL Query can't be represented graphically. Continue anyway?

## CAUSE

This behavior occurs if you are using a Paradox table file that does not contain an index.
Normally you receive this error message when Microsoft Query can't display the Table pane for a given query. However, when you create a query using an unkeyed Paradox table, you receive the error message when you edit the SQL command directly, regardless of how you edit the command.

## WORKAROUND

To avoid receiving this error message when you edit the SQL command directly in a query using a Paradox table, do one of the following to create an index on a field in the table:

- If your table contains data, you must open the table in Paradox and assign a primary key to one of the fields in your table. Until you define a primary key in the table, you cannot edit the data in the table in Microsoft Query. -or-
- If your table does not contain any data, you can create an index in the table by using the following steps:
  1. From the File menu, choose Table Definition.
  2. From the Available Data Sources list, select the Paradox data source, and choose Use.
  3. From the Table Name list, select the unkeyed Paradox table that does not contain any data. Choose Index.
  4. In the Index Name box, enter the name of the table. For Paradox files, the index name must be the same as the table name.
  5. From the Index Fields list, select the field that you want to index. Choose OK.

## MORE INFORMATION

For additional information, please see the following article(s) in the Microsoft Knowledge Base:

111046 MSQuery Err Msg: "Cannot Define Primary" in Paradox Table

## REFERENCES

To view the Error Message Reference, choose the Search button in Help and type:

error messages

Additional query words: 5.00 5.00c MSQUERY

Keywords: KB124106