Mass replace table in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I perform a mass replace a table that is used in multiple queries?
For example, I want to replce Table A with Table B in 20 queries. Both
tables contain the same fields & data types. Table A is a linked table,
Table B is not. Thank you.
 
If you are sure, sure, sure that all fields are identical, you can Export
table "B" to Excel and Import it again as table "A" and when ask if you want
to replace existing table you respond "Yes".

As precaution, have both table copy and pasted with "A2" and "B2" just in
case.

Some user just change the name but I have encounter some probles with
reports doing name swap.
 
Back
Top