hi,


i want to know how to copy tables from one database to another database in vb using ado

I think you need to tell a bit more.
From where??? to where???
Are you copying tables from Oracle to Access? to SQL service?
From Access to Oracle? Access to Access?

If Access is in the picture, look in VBA help - there are some instructions there how to do it. Also in VB or VBA Help you'll find various object models where table is an object and copying is a method. Or you might get away with the import command (Access import/export) right inside Access.