>Hi all,
>I have a text file. I want to read it line by line.
>What is the best way to do this?
>Thanks

Hi Reza

I believe the fastest thing is to create a temporary table with field names and data types that match the system you're importing into.

Append from the text file into the temporary table. Fix anything that's not quite right.

Scan the temp table and insert/update data in the the real table(s).