Productivity Skills

Meta Thinking, Meta Working

Tagged: Provider

Excel VBA Coding Patterns

Creating 32bit Provider Connection String in 64bit OS

Introduces how to create a 32bit Provider Connection String on a 64bit OS. Previous Post VBA Coding Pattern: Importing DB Query Results to Excel_ConnectionString Creation Method 1. I mentioned “How to display 32bit Provider in 64bit OS” in the contents of using UDL file. If you create a connection string with a UDL file on a 64-bit OS, you can basically only create it with the installed 64-bit Provider. Windows 10 in this article...

Excel VBA Coding Patterns

VBA Coding Pattern: Importing DB Query Results to Excel

Introducing the VBA coding pattern that implements importing DB Query results to Excel. Related Article: VBA Coding Pattern: Creating ADO DB Connection String 1. Excel Screen and Operation Method 1.1. Enter the connection string to connect to the DB in cell “B1” of the Excel screen, and in cell “B2” to extract data...

en_USEnglish
ko_KR한국어 zh_CN简体中文 ja日本語 de_DEDeutsch es_ESEspañol en_USEnglish