by Paul Kelly | | Copying Data, Databases, Vault Video
Webinar Number: W0058 This webinar includes: Why querying data using standard VBA is problematic. What is ADO and how can I use it. How to easily set up ADO using VBA code. How to use SQL to perform a simple query. How to write the query results to a worksheet....
by Paul Kelly | | Databases, Vault Video
Webinar Number: W0025 If you are using Excel then a database is never too far away. Being able to connect to a database can greatly enhance the potential of your application. In this webinar, I will show you how to read data from an Access database and write it to a...