copy a table from an access file to another

What's the docmd object and how can I create an instance of it in c#



Answer this question

copy a table from an access file to another

  • Barrios

    I'm sorry, I misinterpretted and didn't notice this was in the C# forum, so I answered assuming you were doing this from VBA within Access.

    Do you just want to copy the data, or the entire table with primary keys etc.   If you're just copying the data, it's as easy as reading from one table into a datatable and then inserting the data into the destination table.  If you need to create the table as well, it's a little more difficult.

    Josh

  • tronn

    I need to copy whole table.

  • copy a table from an access file to another