locked
Copy OleDb table, with schema and data RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am using OleDbConnection to Access databases, in a VB 2010 Windows Form Application.

    Trying to figure out how to copy a table from one OleDb database and add it to another, complete with column properties, keys and indexes. The table data is not an issue here.

    I can successfully copy the table between databases using SELECT INTO, but changes I make to the table in the source database dont come thru. 







    Thursday, March 24, 2016 10:13 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote 
    Dim cnLocal As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Docs\dbFrom.mdb;")

cnLocal.Open()

Dim cmd As New System.Data.OleDb.OleDbCommand("SELECT * INTO [;DATABASE=C:\Docs\DBTo.mdb;].[Header] FROM Header WHERE ID = 2", cnLocal)
cmd.ExecuteNonQuery()

    The code above seems to work.  You have to drop the target table first.

    Found the code here:

    https://stackoverflow.com/questions/7468495/vb-net-ms-access-inserting-rows-from-one-db-to-another

    Friday, March 25, 2016 1:11 AM