This procedure has been tested on Microsoft Excel 365 but it should work in previous versions back up to Excel 2007. The ADO library allows for programmatic access (e.g., from VBA) to databases and other data sources and is included in any standard Office installation by default. This article illustrates how you can use the ActiveX Data Objects (ADO) library and standard SQL to access data tables in Microsoft Excel workbooks as if they where tables from a SQL RDBMS.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |