none
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?

     

    TIA

    Friday, September 7, 2007 10:03 AM