Steve,

Yes the values are going to be in variables only. Data is completely dynamic.

I just hard coded it to show on the forum as an example.

How can i pass chr(13)+chr(10) programmatically before i execute my query.

the data i get from the text file.

I read the text file and assign the data of the text file to a varible and then i fire the query.

Thank you very much.