Export an Access Database Table or Query to Excel

Category:
Database
Type:
Modules
Difficulty:
Intermediate
Author:
Anonymous

Version Compatibility: Visual Basic 6

More information:
This short application will export a given Access database table or query into an excel sheet. The first line wich can start on at a given position will contain the fields name in bold and with a colored shape. Put the bilbio.mdb file (comes with VB) into the application directory for this code to work as written.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download export2xl.zip