[RESOLVED] Delete tables from database programatically

[mindloop]

hy there ,
i have a database with numerous tables and i need to make a copy of it, then delete the tables i don't need, leaving only one table in the copied file.
is this possible ? modifying the .mdb structure through vb.net?
i need this so that i can export data from one table only in a single file, and the other tables are just taking up space (the whole database has 6 mb when it is empty and is not very portable.)
i could store a database containing only my desired table with the program files for this purpose only, but i was wondering if there is another way as i don't like this solution.
any ideeas ?

[tolisss]

cnNew.Open()
        cmd = New OleDbCommand("DROP Table TABLE_NAME", cnNew)
        Try
            cmd.ExecuteNonQuery()
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

[mindloop]

thanks i guess that will do, didn't expect it to be as simple.