/// <summary>
/// Copies table from one database to another.
/// deletes original table in target
/// </summary>
/// <param name="filenameSource"></param>
/// <param name="filenameTarget"></param>
/// <param name="tableName"></param>
public static void CopyTable(string filenameSource, string filenameTarget, string tableName)
{
string sql = "delete * from " + tableName;
AccessDB.RunSqlCommand(filenameTarget, sql);
AccessDB.InsertTable(AccessDB.ReadTable(filenameSource, tableName), filenameTarget);
}
/// <summary>executes a sql command </summary>
public override int RunSqlCommand(string sql)
{
return(AccessDB.RunSqlCommand(filename, sql));
}