One of my uses of Macro is to retrieve records from databases such as sql, Dbase, Access, etc. While MS Query in Excel could do the job pretty well, the database files cannot be shift to other folders. With Macro, this become a possibility. But the main reason for using Macro is I could retrieve records from more complex databases without using additional software. And since my clients like the records to be presented in Excel, this approach becomes a perfect option for me. Accessing databases using macro is relatively easy with ADODB. All you need is a connection, a sql link and a command to present the records in Excel. Take a look at this ADODB page written specially for this purpose.

Leave a Reply