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”

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)”

Enterprise Manager is versatile OSAS to Microsoft Excel link

By Larry Teren

If you feel at home using Microsoft Excel and want your business accounting software to integrate with it, consider the Enterprise Manager your friend. Basis’ Enterprise Manager has been a welcome utility for Open Systems Accounting Software (OSAS) users since its inception a few years ago. The Enterprise Manager is included for free ever since the bbj version (java enhanced business basic) was adopted for OSAS. Continue reading “Enterprise Manager is versatile OSAS to Microsoft Excel link”