See a thread from just a day or two ago "Pulling a name from an Access
database and putting it in Excel" where SQL is used to query an Access
database, write to it and add new records to it.

That code can be used more or less exactly as is for non-Access
databases, you just need to change the connection string.