CHANGE DESTINATION FOR APPEND QUERY

[pauld]

I built an Append Query to move records from a Table in one database to a
different table in another database.

I have since changed the location of the destination database and suspect I
need to change the path I indicated when I built the Query (using the Wizard).

How do I find where the destination path is so that I can change it?

Thanks to everyone who contributes to all of the questions. They are really
helpful.

 

[fredg]

I built an Append Query to move records from a Table in one database to a
different table in another database.

I have since changed the location of the destination database and suspect I
need to change the path I indicated when I built the Query (using the Wizard).

How do I find where the destination path is so that I can change it?

Thanks to everyone who contributes to all of the questions. They are really
helpful.

Open the query in Design View. Click on View + SQL View.
You'll see something like

INSERT INTO MyTableName IN 'C:\MyFolder\MyDb.mdb' ....etc.

Change ithe path there.

 

[Wayne-I-M]

Open the query in design view (or a copy of it).
Select the query type icon at the top of the screen
Select append
Select the Another Datebase option
Select the browse option
Browse to your other DB