Show data other file (1 Viewer)

[carl024]

show data other file without link table i write this query

SELECT Table2.ename
FROM Table2 F:\database.mdb ;



query not result

 

[tehNellie]

I'd suggest that a linked table would be a preferable solution to burying the fact you're pulling data from an external source in a query (not 100% sure you can query in this manner, but I do know you can export like this).

With a linked table it's immediately apparent that you're importing/querying data from an external source and much easier to update if needed than having to go round and edit a bunch of queries.

 

[khawar]

SELECT Table2.ename
FROM Table2 in 'F:\database.mdb' ;