/// <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)); }