Hi!

I just uploading a new file for download, it will appear soon. If you need it more quickly - send me email and I will send it to you.

The file does converting of the DBF into the TXT file(s) in the format required for exporting text file to SQL Server by the BCP utility (no delimiters for character fields and correct delimiters between fields). There are 3 sets of delimiters that assure that in case delimiter character appears in the field content, another delimiter is used and another TXT file is created. The program is tested as part of the process for transferring data to SQL Server.


>Hi everyone,
>
>VFP6.0 SP5
>
>I have a requirement to create a text file from our database, where delimiters would be |^ (two symbols) and char data would not have quotes. Files have ~250 fields and may be huge.
>
>I'm thinking about two possible approaches:
>1) Scan the file and process it manually (here is a subquestion: do it through textmerge or create chunk string and put this string into file)
>
>2) Use copy to command and process the file afterward (Need some fll to make this replacement).
>
>What do you think would be better? Does somebody have a similar experience and some benchmarking?
>
>Thanks a lot in advance.