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

I am planning on connecting to a microsoft access database sitting on an
nt server (with activestate perl installed) accross a network from a unix box.
I have installed the Perl Modules and configured the ODBC settings as discussed
in 'Programming the Perl DBI', and I am confident that I will be able to connect to
the database.
My problem is actually querying the data on the the database. Do I issue the queries
in SQL as part of the database handle.
If there are already MIcrosoft Access queries on the database can these be fired from
the Perl script and the results returned?

Many thanks in advance to any answers or information returned.