Append Query (Source Table from diff DB)

[imfarhan]

Hi
I would like to use the append query but , the source table should be external database. I want to avoid the link table from (Source). Can I use the path at the end of my append query as follows

INSERT empno,ename INTO emp IN 'N:\InfoCom\Farhan\Test_DB\R&D(Testing).mdb'
SELECT empno, ename From emp_source
'N:\InfoCom\Farhan\Test_DB\R&D(Testing).mdb';
​

So, simply the source table is in different database.

Many thanks
Farhan

 

[imfarhan]

Sorry my query was not clear
I want something like this

INSERT INTO emp ( ID, empno, deptno, ename )
SELECT emp.ID, emp.empno, emp.deptno, emp.ename
FROM emp N:\InfoCom\....\sourcedb.mdb;

Thanks

F