There are several programs that do what you are looking for. I've used "Data Junction" in the past to import in Oracle. It was extremely flexible.

PF

>Hi,
>
>Anyone know of any solid flexible importing program that can map
>from text file of huge legacy data into MS SQL Server 2000.
>
>Or have anyone done any flexible importing program to import
>data.
>
>I hope that with it's flexiblity, we only had to change
>the configuration to import the data without having to
>change/code for each data file.
>
>Any advise or comment is appreciated.
>Thank u