Need assistance to load a kind of a Fox DBF

[#1]

HI !

I used to load a native , typical DBF, simply using this :

ODBC CONNECT TO [dBASE Files];

ASSUNTOS:

LOAD

     TEXT(CODASSUNTO) AS ASSUNTO_KEYP

    ,TEXT(CODASSUNTO) AS ASSUNTO_KEYL

    ,TEXT(CODASSUNTO) AS CODASSUNTO

    ,ASSUNTO

    ,RECNO()          AS RECNO_DER_ASSUNTOS;

SQL SELECT

    *

FROM $(ORIGEM)ARQASS.DBF;

However the file has change it's internal structure to FOX DBF and the statement above no longer works.

How do I load the file now ? There's a sample of this file attached (ARQASS.DBF , inside KIT.ZIP).

Thanks !

[lzimmermann]

Hi,

use OLEDB for FoxPro or ODBC for FoxPro.