Run SQL command on a database and store result in a macro

[Shiamak]

Hi,

Is there a way to connect to a database using a specific user , run a sql command .e.g select abc from abctableA and then store the result in a macro?

Appreciate your help.