|
Subject:
|
Moving data from one table to another
|
|
Posted By:
|
twizted
|
Post Date:
|
1/23/2006 3:05:59 AM
|
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
|
|