i am not an expert in vb6 i just code when i need to do so and i am having a problem... i am importing an excel to my database(mdb) using thread222-691548 as my basis... my problem now... that code creates a table... and when i run it again i receive an error the table is already existing... so the possible solution maybe is to delete that table each and every time the main program runs. i dont know how to do it... i know how to delete records but not the whole table... please advice...