I want to export the 'dbf' file to an ascii , plain text format so that i can port the data to SQL server. Since the DATA BASE FILE is having memo field , it is exporting all fields except memo. I want memo fields also to be included as a string in my plain text file. I used the command 'COPY TO ' and was unsuccessful.

then I used FWRITE and FCLOSE, FOPEN to create a text file and copied the data to text file, but it's speed is not good.

I got one more problem . The Foxpro 2.6 database file is not having some entries in some rows in some fields. and when exported it sent them as NULL, but using the above method, I am not getting NULL values . So can anybody suggest a solution.