SQL connection to DB2

[Carl]

I can run SQL in Excel to bring back data into reports via code no prob.
Now, I would like to have a similar connection in Access. I have a table
that contains a SQL statemnet field. What do I need to run the SQL against a
DB2 database? I am new at Access so be gentle.
Thanks

 

[JoeO]

Have a look at http://www.connectionstrings.com/

 

[JoeO]

And http://www.codemaker.co.uk/it/tips/ado_conn.htm

 

[Carl]

Thank you. I think in have the connection string from Excel. What I really
need is sample code to just run the code.

off the top of my head it would be like

SQLCode = Reports.sql where reportID = 10
ConnectStr = (the connection string)
Set RS = < Now I am lost >