I tried to create a CONNECT table using the following command –

create table cust engine=CONNECT table_type=DBF file_name='test.dbf';

I got an error –

Error Code: 1105. Unsupported DBF type M

I'm assuming DBF type M means that there are Memo fields in use? Or perhaps that means something else.

Anyway, if it's a reasonable request, support for FoxPro tables including memo field support (FPT files) and CDX indexes would be extremely helpful.