Import data from one MS Access database into another MS Access database

Question

I am trying to import data from one MS Access database into another MS Access database and have found the following works fine, problem I have got is does anybody know what I should be using if the from database is locked with a SYSTEM.MDW

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Data\Database1.mdb;User Id=admin;Password=;";
string commandText = "INSERT INTO [TableName] SELECT * FROM [MS Access;DATABASE=C:\\Data\Database2.mdb].[TableName]";

try
{
    using (OleDbConnection oleConnection = new OleDbConnection(connectionString))
    {
        using (OleDbCommand oleCommand = new OleDbCommand(commandText, oleConnection))
        {
            oleCommand.CommandType = CommandType.Text;
            oleCommand.Connection.Open();
            oleCommand.ExecuteNonQuery();      
        }
    }

}
catch (Exception)
{
    throw;
}

I can open the From database using Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Data\Database2.MDB;System Database=C:\Data\SYSTEM.MDW;User ID=Developer;Password=Password

Can this action be done when From DB is not protected in a SYSTEM.MDW? I would guess you need the Access environment to be opened, and run the INSERT statement. I may be wrong, of course... — marlan
– marlan, Commented May 5, 2016 at 12:11

marlan · Accepted Answer · 2016-05-05 12:25:44Z

0

If you can open the From database, open it and do the action from it:

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Data\Database2.MDB;System Database=C:\Data\SYSTEM.MDW;User ID=Developer;Password=Password";
string commandText = "INSERT INTO [TableName] In 'C:\\Data\Database1.mdb' SELECT * FROM [TableName]";
try
{
    using (OleDbConnection oleConnection = new OleDbConnection(connectionString))
    {
        using (OleDbCommand oleCommand = new OleDbCommand(commandText, oleConnection))
        {
            oleCommand.CommandType = CommandType.Text;
            oleCommand.Connection.Open();
            oleCommand.ExecuteNonQuery();      
        }
    }

}
catch (Exception)
{
    throw;
}

answered May 5, 2016 at 12:25

marlan

1,4851 gold badge12 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Import data from one MS Access database into another MS Access database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related