clone table between MDBs RRS feed

  • Question

  • Hi,


    I have two MDBs,  ACCESS97 format.  In A.MDB I have a table "MyTable" which I need to clone (only struct or struct + data) in the B.MDB.


    I have tried to examine MyTable struct via GetOleDbSchemaTable(), but I noticed that seem no way to obtain the allowed-value-rule (definied ad field level). Also the dataType returned for an "id" sequence-column is only integer (and not auto-increment integer).


    Is there any (simple) way to clone the table?



    Friday, September 7, 2007 10:03 AM