SQL can be used to import external data  from a database. If you open import
external data and do not use the wizard there is a button in MS query to do
that.

You can also use SQL strings programatically. It requires an understanding of
???DAO or ???ADO (a bit outside my area of expertise, tho I have used it in
Access.).