Chapter 2. Using the Excel User Interface

 < Day Day Up > 

I first realized how powerful integrating Access and Excel could be while I worked for a company that calculated incentives. A database housed all of the data required to calculate the incentives. Before I took over the process, a report was printed from the database and rekeyed into an Excel workbook that performed all of the calculations. Eventually we moved from rekeying, to using Microsoft Query to pull data from the database, to finally having the database fill in the Excel workbook. Using an automated process not only saved time, but it also dramatically reduced errors. In the years since, I have found many more opportunities to integrate Access and Excel.

While it is tempting to jump right into using VBA to perform data functions, understanding when and how to use the Excel interface is still very useful and can provide a springboard to using VBA. When you want to use External Data from the Excel user interface , use the Import External Data function under the Data menu. From here, you can open and edit saved queries or create a new query.

     < Day Day Up > 


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

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