Thanks for visiting our website today!

Would you like to chat with us right now
about your programming/support needs?

Click Here To Chat With Us Now Live!!
     No thanks.

Contact Us Contact Web Professionals 
 
Skype™ Skype Call Email Email The Microsoft Excel Experts
Iowa Headquarters
(MIDWEST)
103 E. 6th St., Suite 101
P.O. Box 726
Ames, Iowa 50010
Tel: (515) 239-9900
Fax: (515) 239-9800

Driving Directions to the Ames Iowa Headquarters
Florida Headquarters
(Southeast)
4200 Evans Ave., Suite 10
Fort Myers, Florida 33901
Tel: (239) 267-2749
Fax: (239) 267-9936

Driving Directions to the Fort Myers Florida Headquarters
Want quick Answers?
During normal business hours you can reach us via our live chat program.  Try it, it's really cool!!
 
Partner Locations
Quad Cities, Iowa
Cedar Rapids, Iowa
 

Microsoft Excel Sample Code

Function for using Access Automation

Access Automation is a very powerful technique where you can communicate with an access database from within VBA code in your Excel Document. This allows you to do some very powerful things, such as populating an existing database with data from your speadsheet, taking advantage of access tables you've already setup, dump data into a database and wide variety of other uses. The demo application below shows a very simple example of how to interact with Access from within your Excel Application.

The Microsoft Excel Access Automation Database is a sample database that shows you how to implement Access Automation inside your own Excel Spreadsheet.

Please note that this is a template database. If it doesn't meet your needs 100% and you're unable to customize it yourself, let us know and we'll provide a quote to develop the customizations you need to get you exactly what you want in your Excel Access Automation Database System.

Excel Automation Form

Access Automation Form

Access Automation Table

Try out the demo to see if the demo works for you.

Download a demo version for free to try out. The demo version is in Excel 2007 which will work on either Excel 2007, 2010 or 2013. If you need a previous version of Excel to tryout, please Contact Us. Please note that the demo version of the software is fully functional but doesn't allow you to see the code implementation - the full version allows you to design the code implementation and tweak it for your needs.

The full version of the file is a standard Excel file. You will have full access to all the visual basic project code and you will be able to modify or add to the design in any way that you wish. If you lack the time to integrate this database into your system, please Contact Us and we'll be glad to help. If you like the basics of what you see, but need enhancements to make the system functional for you, please Contact Us and we'll develop a quote for you to implement the additional features and enhancements that you need.

The cost of the Access Access Automation Database is as follows:

$24.99 - this allows you to use this database template however you wish within your organization.
$49.99 - for unlimited developer use - this allows you to use this database template however you wish for any applications you develop and distribute.

Once your purchase is complete - you will receive an email with a link to download the full version of the database.