Hello to all.
I知 trying to use Excel 2007 to extract data from an Access 2007 database using ADODB. I know how to connect to the database. What I知 trying to achieve is to write the SQL query with parameters (using the worksheet cells) and then write a user defined function to refresh the recordset.
Does anyone have a piece of code to share where I can learn the basics to get this?
Thanks in advance for any kind help.
Octavio.