Need assistance to load a kind of a Fox DBF

Mon, 23 Jul 2012 18:29:44 GMT

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 !

Re: Need assistance to load a kind of a Fox DBF

lzimmermann — Tue, 24 Jul 2012 07:18:48 GMT

Hi,

use OLEDB for FoxPro or ODBC for FoxPro.