Export an Access Database Table or Query to Excel
Version Compatibility: Visual Basic 6
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.