OK here's my situation, I have two access databases and what I want to do is to copy all the tables that are in the one, to the other.

So far I have the tables filled into a dataset/datatable from the one database, now how do I create the exact same table with properties in the other database and then export that datatable/dataset to the other database. Bare in mind that I do not know the columns and/or types of the columns for each table, unless i physically opened up the database, which I cannot do.

If any of you could possibly help mewith this problem, I will very much appreciate it.

Thanks,
sc