Dear All,
I want to use a SELECT statement in an INSERT statement but different Database (ASA and Ms. Access)
I have 2 tables in 2 different databases.

Table ZN is in ASA
Table PAC is in Ms. Access

How to insert ZN by using SELECT statement?

I thought it is impossible to use below SQL statement..

Dim mInsertZN As String
mInsertZN = "INSERT INTO ZN (ZN) SELECT DISTINCT ZN FROM PAC ORDER BY ZN"

I need advise ..

many thanks in advance
Regards
Winanjaya