/// <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>Retuns a DataTable</summary>
public override DataTable Table(string tableName)
{
return(AccessDB.ReadTable(filename, tableName));
}