i have a text file with data like this: Student_ID Lic_No ---------- --------- 333 11112222 444 22221111 555 33336666 ... and so on. This is pure text file. In the database, I have a column called 'Student_ID'. I have created a new column called Lic_No in the database. I want to put the Lic_No info into the database. If I do it individually I would say: Update tbl_Student set Lic_No = '11112222' where Student_ID = '333' But, it is going to be very painful to do it individually. I am sure there is an easy way. Can someone tell me how. Thanks all. Mirza __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.