>Thanks Mark,
> I found that in the loop, I was trying to insert data in some new tables. If the table name already exist, it gives me an error message"File in use." Can I check if the table exist, if it exist, I can delete that before inserting the data.
>
>Thanks
>Bharat

USED('MyTable') returns true if the table is already open in the current data session. If it returns true, you can issue USE IN MYTABLE to close that table. If you are appending records into that table, issue a SELECT MYTABLE first. If you are issuing an INSERT INTO MYTABLE command, you do not need to do anything other than issue that SQL command. So, I do not really follow what you mean by deleting the existing table before inserting the data.