pjp3 has asked for the wisdom of the Perl Monks concerning the following question:

using odbc,is there a way to use a sql insert statement on one mdb with an embedded select on a different mdb? If not, is there any way to do that sql with perl?

Replies are listed 'Best First'.
Re: odbc sql statement using 2 mdb
by marto (Cardinal) on Oct 05, 2006 at 18:12 UTC
    pjp3,

    What have you tried so far? Just to make sure we are on the same page, your going to have two data sources, one for each MS Access DB, and you want to generate an insert into one database which depends on the results of a SQL statement from the other database? Is this correct so far? If this is correct then why not store the results of the select statement then use the results to generate the insert for the other database?

    Hope this helps.

    Martin
[reply]
    A reply falls below the community's threshold of quality. You may see it by logging in.

Back to Seekers of Perl Wisdom