Like almost any web site, we use technologies like cookies to store and/or access device information. We aim to keep that to a minimum. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions. We apologize for this box but it's legally required in some regions.
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
The technical storage or access that is used exclusively for statistical purposes.
The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Access Archon: Working with EXCEL
Helen Feddema, editor of Access Watch, shows you many different ways to exchange data between Access data and Excel worksheets.
There are up to seven different ways to exchange information between the programs. Access Archon: Working with Excel goes through all of them discussing the advantages and disadvantages.
$9.95 – $16.95
Description
“This has been a valuable resource for me. Thanks for writing the book.” – Patrick J B., Cost Estimator, Fresno CA
Access is a great database, Excel is a great worksheet and sometimes you have to copy or connect information between them. Access Archon: Working with Excel shows you how.
Helen Feddema, editor of Access Watch, shows you many different ways to exchange data between Access data and Excel worksheets.
There are up to seven different ways to exchange information between the programs. Access Archon: Working with Excel goes through all of them discussing the advantages and disadvantages.
Each method is covered in detail, with sample code where necessary.
Finally, Helen gives tips on debugging your VBA code. These aren’t your usual simple tips but real world advice from someone who has been working with Access and Excel for well over a decade.
Features
• Seven ways to get data from Access to Excel, depending on your need.
• Six ways to get data from Excel to Access, depending on your need.
• Pros and Cons of each method
• A complete example of exporting data from Access to Excel, and then reimporting new data back into Access from a filled-in worksheet.
• Design techniques for a more useful and attractive main menu for any Access database.
• Code and details for Access & Excel 2002 (XP) through Access & Excel 2010
• Access debugging tips from an expert
• Over 55 pages of original content