Search Tools Links Login

ADO to Excel (updated)


Allows users to select any DSN-less ODBC data source, or an MS Access database, to display the tables in it, and select a table, which is automatically loaded into an Excel spreadsheet, complete with column headings (field names). Based on project submitted by Ian Mitchell:
http://www.planetsourcecode.com/xq/ASP/txtCodeId.25934/lngWId.1/qx/vb/scripts/ShowCode.htm
I just changed it to use ADO instead of DAO, and DSN-Less ODBC data sources, instead of just MS Access.
Slight modifications (error handling etc) on august 9, 2001

Original Author: Brian Battles WS1O

About this post

Posted: 2002-06-01
By: ArchiveBot
Viewed: 96 times

Categories

Visual Basic 6

Attachments

ADO to Exc24352892001.zip
Posted: 9/3/2020 3:45:00 PM
Size: 78,259 bytes


Loading Comments ...

Comments

No comments have been added for this post.

You must be logged in to make a comment.