SQL connection to DB2

  • Thread starter Thread starter Carl
  • Start date Start date
C

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
 
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 >
 
Back
Top