About Me

My photo
Andrew J. Jordan, CPA, MSF is a licensed Certified Public Accountant. He achieved a successful career as a CPA, Financial Manager and Consultant for a variety of large and small businesses. Andrew is experienced in creating value for companies in industries ranging from staffing and professional services, retail automotive dealerships, manufacturing and real estate. He also has over 25 years experience assisting individuals and businesses with income tax planning and compliance. Andrew holds a Bachelor of Science degree in Business Administration from Wayne State University in Detroit, MI and a Master of Science in Finance from Walsh College in Troy, MI. His graduate education included significant elective study in Taxation. His services include: Accounting, Tax and Advisory Services. Visit andrewjordancpa.com for more information.

Wednesday, June 1, 2011

Open Database Connectivity (OBDC) in Excel

     As promised the following is the information on Open Database Connectivity (OBDC) function in Excel.  As you recall from my last blog we covered how Excel can connect to external data to create reports that can be refreshed or updated with current information.  ODBC complaint databases can be connected to Excel using the Data Connection Wizard or Microsoft Query.
     Microsoft Access can be used to extract data stored in external databases and then the data is transferred to Excel to create reports.  But if your accounting software supports ODBC, then Excel can access your historical data in your general ledger directly without re-keying any data or going