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?
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