• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• ADO to Excel (updated)

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:
https://www.vbcoders.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

Rate ADO to Excel (updated)

• 1
• 2
• 3
• 4
• 5

(16(16 Vote))

Download ADO to Excel (updated)