ExportToExcel_TransferSpreadsheet (intermediate)

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

This sample demonstrates how to export data from a database to an Excel Spreadsheet using the TransferSpreadsheet method.

The overall process:

1) Create macro to export queries

2) Convert the macro to VBA code

3) Modify the code to loop through a table of table and file names (MyExport)

Look in the "basExport_TransferSpreadsheet" module for the relevant code. 

Download Sample (accdb): ExportToExcel_TransferSpreadsheet
Download MDB version

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Roger Carlson Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 253	Post Options Post Reply Quote Roger Carlson Report Post Thanks(0) Quote Reply Topic: ExportToExcel_TransferSpreadsheet (intermediate) Posted: 10 May 2016 at 10:36am
	This sample demonstrates how to export data from a database to an Excel Spreadsheet using the TransferSpreadsheet method. The overall process: 1) Create macro to export queries 2) Convert the macro to VBA code 3) Modify the code to loop through a table of table and file names (MyExport) Look in the "basExport_TransferSpreadsheet" module for the relevant code. Download Sample (accdb): ExportToExcel_TransferSpreadsheet Download MDB version
	Consider donating $1 per sample downloaded, find out why here.<

Sponsored Links