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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only