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