Error 7200 when working with certain .dbf files

Avatar
  • updated
  • Completed

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?

Avatar
ejohanss

Additional error information when "browsing" the file.

Error 7200: AQE Error: State = HY000; NativeError = 5025; [iAnywhere Solutions][Advantage SQL][ASA] Error 5025: An invalid table type was specified. Valid choices are ADS_ADT, ADS_VFP, ADS_CDX, and ADS_NTX. The table type must support the memo file type to be opened, if applicable. Should have been ADS_NTX. Table name: QuikAgts.dbf

Avatar
ejohanss

Furthermore, the .dbt memo file IS located in the same directory as the .dbf

Avatar
Anonymous

Hello,

There are some unsupported types of DBF files. FlySpeed SQL Query uses Advantage SQL Engine to work with DBF files. If this engine doesn't support them, we can't do anything with this. But you can send one of the problematic files for investigation.