Error 7200 when working with certain .dbf files
I am working with three .dbf files, and two of them import correctly. Table structure remains intact, and query builder works great.
However, the third dbf causes this error when viewing contents:
Error 7200: AQE Error: State = 42000; NativeError = 2115; [iAnywhere Solutions][Advantage SQL Engine]Expected lexical element not found: FROM You are missing the keyword FROM after the column definitions in your SELECT statement. -- Location of error in the SQL statement is: 279
I can open this .dbf in Excel and it clearly is not corrupt.
How to fix?