>Hello all:
>
>We are converting a FoxPro data load program to be all MS SQL Server.
>
>We presently use the FoxPro command:
>
>APPEND FROM "f:\narbook\nar010610.txt" TYPE SDF
>
>To get the text file into a foxpro table.
>
>The foxpro table has several fields that are all character.
>
>What I need is a way to load the same data into a MS SQl Server table of the same structure.
>
>We have tried several methods and all seem to have issues getting the data into the correct field.
>
>Any help or direction would be appreciated.
>
>TIA
Check Message #
886662 for a sample.
Cetin