Re: Convert to dbf format

Two simple steps;
1. Get the sql to create an acii file output.txt with each column's value

    enclosed in " " (double qutoes) and seperated by ',' (comma).

  EX:

     "A","B","C"
     "1","2","3"

2. Startup dbase/foxpro and create an empty stru (say myfile.dbf)

    that you need and use the command "APPEND from ouput.txt to     myfile.dbf type delimited" - (I am not sure of the syntax pl verify)

hope this helps.

regards,
Subu.

Joep Hendrix wrote in message <35F432CF.4A7A_at_wxs.nl>...
>Hi,
>
>I need to write a batch sql script of which the output is in a dbase4
>(DBF) format. As far as I know this format is binary. Does anybody know
>a tool or work-around that could automatically convert from ASCII into
>dbf format.
>
>Thanks in advance,
>
>Joep Hendrix
Received on Fri Sep 11 1998 - 22:07:03 CEST