Roger's Access Library Homepage
Forum Home Forum Home > Roger's Access Library > Roger's Download Samples
  New Posts New Posts RSS Feed - AppendValuesToExcel.mdb (intermediate) (2000-2003)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)

AppendValuesToExcel.mdb (intermediate) (2000-2003)

 Post Reply Post Reply
Roger Carlson View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 20 Feb 2008
Status: Offline
Points: 261
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roger Carlson Quote  Post ReplyReply Direct Link To This Post Topic: AppendValuesToExcel.mdb (intermediate) (2000-2003)
    Posted: 10 Nov 2009 at 7:13am

Please consider donating $1 per sample downloaded, find out why here.

This sample demonstrates how to append data from a database to an Excel Spreadsheet using Office Automation to find the next empty row in the spreadsheet.
The overall process:

1) Define Access and Excel object variables

2) Open Excel sheet as an Excel Object

3) Find the last row of data

4) Write data from Access query to Spreadsheet

5) Save and close spreadsheet

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

Note:  This requires a spreadsheet called "ExportSpreadsheet.xls" (included with the sample) exist in the same directory as the  application.  Also requires references set to DAO 3.6 and Excel
Download Access 2000-2003 Version:
Consider donating $1 per sample downloaded, find out why here.<
Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.