You should consdider using SSIS, BCP or BULK INSERT. SSIS would be my preferred method because it allows to map data in a text file to a table fields and do necessary conversions in the process.

>
>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