CHANGE DESTINATION FOR APPEND QUERY

  • Thread starter Thread starter pauld
  • Start date Start date
P

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.
 
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.
Click to expand...

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.
 
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
 
Back
Top