4.6. Next Steps

 < Day Day Up > 

This chapter covered some very basic functionality that exists in Access to deal with outside data sources, including Excel. Most of the functionality can be applied to other data sources as well. While these features can be very useful, I would guess that after you finish this book you'll use the more advanced functionality of Access VBA for most of your reporting tasks. The features covered in this chapter, therefore, will be used on a more ad hoc basis. Having said that, it is critical to understand how these features work because over time you will probably use each of them.

The other important item to note is that Access and Excel have very similar functionality with respect to data access. Because of that, people often use the feature that they know instead of the feature that will best solve the problem. It is because of those times that I think you should understand all of the features so you can make the best decision.

Finally, most of the features covered in this chapter can be automated by using Access VBA. This will be more relevant in future chapters, but if you have 20 or 30 Excel files to process, you would do yourself a big favor by learning a small amount of VBA to automate the process instead of doing each file individually.

     < Day Day Up > 

    Integrating Excel and Access
    Integrating Excel and Access
    ISBN: 0596009739
    EAN: 2147483647
    Year: 2005
    Pages: 132

    Similar book on Amazon

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net