View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tek.hong@gmail.com is offline
external usenet poster
 
Posts: 4
Default 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