Winan,

I am not sure what version of ASA you are using. In version 8 or 9 you can use proxy tables to do this. You would setup a proxy table to the Access table and then do your select from ASA.

>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