Using ADO with Non Standard Data Sources

This section describes how you can use ADO to access data from two common non-standard data sources (data sources that are not strictly considered databases), Excel workbooks, and text files. Although the idea may seem somewhat counterintuitive, ADO is often the best choice for retrieving data from workbooks and text files because it eliminates the often lengthy process of opening them in Excel. Using ADO also allows you to take advantage of the power of SQL to do exactly what you want in the process.

0 0

Post a comment