I don't think there is such a thing as an import program that does not require some knowledge. Typically these tools require you map the imported data to fields in your database, and also offer transformation for cases like importing a character field into a date.

PF

>Hi,
>
>Yes, I had look at DTS, but it require knowledge in it and
>some sort of programming stuff to get it working.
>
>
>>Have you taken a look at DTS (Data Transformation Services) in SQL Server 2000?
>>
>>>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