Skip to content

Accounting Software Tips

Tips on how to maximize Accounting Software features

Category: ODBC

Accessing OSAS Data in Excel

By Larry Teren

1. Go to Microsoft Excel. (The screen shots used here are from Microsoft Excel 2010)

2. Click the DATA tab and the FROM OTHER SOURCES. Slide down to FROM MICROSOFT QUERY and click (See screenshot below). Continue reading “Accessing OSAS Data in Excel”

Share this:

  • Email
  • Facebook
  • Twitter
Author Larry TerenPosted on July 29, 2012Categories Microsoft Excel, ODBC, Open System Accounting Software, OSASTags Microsoft Excel, Open Systems Accounting Software, OSASLeave a comment on Accessing OSAS Data in Excel

ODBC Setup in Control Panel for Open Systems Accounting Software (OSAS)

By Larry Teren

1. Click on access to Control Panel link.

On Windows XP, click Administrative Tools Link Continue reading “ODBC Setup in Control Panel for Open Systems Accounting Software (OSAS)”

Share this:

  • Email
  • Facebook
  • Twitter
Author Larry TerenPosted on July 29, 2012July 29, 2012Categories Microsoft Excel, ODBC, Open System Accounting Software, OSASTags Open Systems Accounting Software, OSAS, OSAS ODBC SetupLeave a comment on ODBC Setup in Control Panel for Open Systems Accounting Software (OSAS)

Blog Search

Site Sponsor

Larry Teren & Associates

ph: (773) 502-5771
email: info@lteren.com

Recent Posts

  • Moving Your Accounting System to the Cloud
  • Thinking of Using NetSuite?
  • The Politics of Software Migration
  • Data Transfer to a New System
  • Company Vs. Customer Specific

Categories

  • Accounting System
  • apply credit memo and payment to AR invoice
  • Average Cost formula
  • Benefits of Using Open Systems Accounting Software
  • Cloud Computing
  • Commission Tracking
  • computer consulting
  • Contractor Job Cost Accounting
  • Enterprise Manager
  • General Contractor
  • Microsoft Excel
  • ODBC
  • Open System Accounting Software
  • OSAS
  • Purchase Order
  • software migration
  • SQL
  • Uncategorized

Tags

  • apply credit memo to invoice
  • Benefits of buying Open Systems Accounting Software (OSAS)
  • Cloud Computing
  • Enterprise Manager
  • How to close out older purchase orders in OSAS
  • Microsoft Excel
  • Open Systems Accounting Software
  • OSAS
  • OSAS Average Cost formula
  • OSAS ODBC Setup
  • SQL Query
  • Why Purchase Open Systems Accounting Software?
Accounting Software Tips Proudly powered by WordPress