kalam wrote: I want to write a program in VB 6.0 you put the question in wrong forum !!! try it in VB Section !!! Good luck!!! Best Regards ----------------- Abhijit Jana Microsoft Certified Professional "Success is Journey it's not a destination"

Hi, You can use as many temp table you want.But after doing transaction you have to delete those temp table. Regard's Veeresh i want to join this group

Can you not provide the named columns in the select statement: e.g. Select cola, othercolumnname from excelimport