Export an Access Database Table or Query to Excel
Category:
DatabaseType:
ModulesDifficulty:
IntermediateAuthor:
AnonymousVersion 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