Append from table in another database

  • Thread starter Thread starter Dale Fye
  • Start date Start date
D

Dale Fye

I'm trying to write a query that will allow me to append records from
one database that do not already exist in my destination database. I
know how to select records from the source database, but when I try to
create a query that joins the two tables, on in the source and the
other in the destination, I get an error (Syntax error in FROM Clause)
and the cursor highlights the LEFT in Left Join.

Anyone know how to rewrite this to allow me to link the two tables
from different databases? I know I could import the source table, but
figure that would take longer.

SELECT S.*, D.*
FROM tbl_Observations S IN 'H:\Events\Unified Course (Oct
03)\export1.mdb'
LEFT JOIN tbl_Objectives AS D ON S.Obs_ID = D.Obs_ID AND S.Obsn_ID =
D.Obsn_ID
WHERE D.Obs_ID IS NULL
 
I would suggest that you Link the table from the outside
source, in to the database where you have your query. I
believe that should solve your problem. And, by linking
the data, it does not increase the size of your current
database. To link, you would Clike on "File", then "Get
External Data", then "Link Tables". Then you would browse
to your outside source and select the database that
contains the table you are needing. When the window opens
up, just click on the table and then click on Link Table.
Change your query to now have this table in it, instead of
the outside source and try to run.
 
Back
Top