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: AppendValuesToExcel.zip
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Top 10 benefits of Access 2010 1 Get started faster and easier than ever before . Harness the power of the community in Access 2010. Buil...
-
During the era of scientific management, Henry Gantt developed a tool for displaying the progression of a project in the form of a specializ... -
Trainer: Don Jones Videos: 20 Time: 6 hrs This series shows you how to build Web applications for Windows, using version 4 of the .NET Fra...
-
A concise, focused study aid aimed at preparing you for PMP certification The Project Management Profressional (PMP) certification is the... -
Product Description Fast answers to frequently asked questions Excel 2007 essentials at your fingertips! If you like your answers quic... -
Video learn for Project management , PMP CBT nuggets , I would like to thank this company about what they added value This is introduction...
-
Project management Essay Lets discuss about project management , the project management is Skills and techniques, project management sk...
-
This sample is a useful template for an application. It has a number of standard forms for maintaining reference tables, viewing reports,...
-
By Cyndi Snyder Stackpole, MBA, PMP 26 Jan2009 A lot of people are wondering what is going to change with the PMBOK® Guide: Fourth Edit...
No comments:
Post a Comment