ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

Valid HTML 4.01 Transitional

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Document: Description: Sort by name
ADO Connection Strings Example ADO connection strings that can be used when connecting to some of the most common database types using ODBC 2005-10-08
Export data from Excel to Access (ADO) Export data from an Excel worksheet to an Access table (ADO). 2005-02-01
Import data from a large text file to multiple worksheets (ADO) Read data from a text file and write the contents to multiple worksheets (ADO). 2004-12-17
Import data from a text file (ADO) Read data from a text file and write the contents to a worksheet (ADO). 2002-04-02
Import data from Access to Excel (ADO) Import data from an Access table to an Excel worksheet (ADO). 2001-11-27
Export data from Excel to Access (DAO) Export data from an Excel worksheet to an Access table (DAO). 2001-11-27
Transfer data from a recordset to a worksheet (ADO) Transfer data from a recordset to a worksheet without using the CopyFromRecordset method (ADO). 2001-11-27
Use a closed workbook as a database (ADO) Read data from and write data to workbooks without opening them (ADO). 2001-11-11
Use a closed workbook as a database (DAO) Read data from and write data to workbooks without opening them (DAO). 2001-11-11
Import data from a closed workbook (ADO) Import data from a closed Excel workbook without opening it (ADO). 2000-09-16
Import data from Access to Excel (DAO) Import data from an Access table to an Excel worksheet (DAO). 2000-02-05
Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address