Dear Expert,
Actually I have so many link table which connected to backend SQL Server by ODBC. In the Access Form View I created a combo for list of all table name. I just want to select a table name from the combo and then click a command button which will generate a pass-through query to remove all data from selected table in the combo. And then import new text file in same table.
Thanks
Mir
Actually I have so many link table which connected to backend SQL Server by ODBC. In the Access Form View I created a combo for list of all table name. I just want to select a table name from the combo and then click a command button which will generate a pass-through query to remove all data from selected table in the combo. And then import new text file in same table.
Thanks
Mir