AcuODBC User's Guide
Version 6.0

4.1 Working With Windows Applications

The easiest way to access your COBOL data (now an ODBC data source) is using Microsoft Query, a database query tool that comes with Microsoft Office. You can invoke Query directly from Windows applications like Microsoft Word and Excel. Once in Query, you can navigate through a series of menus to create automatic SQL statements for the ODBC driver manager. ODBC calls to ACUCOBOL(TM)-GT data are totally transparent when you use Query. Other Windows programs, like Microsoft Access, Crystal Reports Professional, and the Microsoft Visual Basic development system, have their own interfaces to ODBC data sources.

This chapter describes how to retrieve ACUCOBOL-GT data from three of the most popular Windows applications: Microsoft Word, Excel, and Access. For instructions on accessing an ODBC data source from other Windows applications, refer to the application-specific user documentation. The examples in this chapter are based on the sample data source that comes with the AcuODBC® interface. If you have already read Chapters 5 or 6 and worked with these files, your results may look slightly different.

Note: It is important to be aware of how many fields your application supports for a primary key. For example, Vision files can support 16 columns in a primary key. Microsoft Access, on the other hand, supports only 10 columns in a primary key. If your application does not support as many fields as your data, you can receive unexpected results.


Accessing Data From Word 97 and 2000

Accessing Data From Excel 97 and 2000

Accessing Data From Access 97 and 2000

Acucorp, Inc.
Voice: (800) 262-6585 (U.S.A. and Canada)
Voice: (858) 689-4500
Fax: (858) 689-4550

Please share your comments on this manual
or on any Acucorp documentation with the
Acucorp Communications Department.
© 1988-2003 Acucorp, Inc.
All rights reserved.