How to access MSSQL table in a user defined function
Hi
I would appreciate if someone could help me with some sample code that
I can use in my custom function to access a ODBC database and send a
SQL statement to retrieve data from a table.
BTW, how can I store the ADO recordset in a array so that my VBA
function can manipulate?
Your advice most appreciated. Thanks
Best Regards
|