<div>
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
</div>


This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.

<div>
<div class="content wysiwyg-content">
Need to learn how to use my Pervasive SQL9 database and connect it via ODBC.<br />
<br />
Trying to create excel reports and access 2007 to analysis our data from this database system.<br />
<br />
Currently we are using Small Business Server 2003 using the Pervasive SQL9 software as our database for Magic eDeveloper 9.4 as our production system. Normally I retrieve data using Crystal Reports by using DDF files thru Betrieve connection.<br />
<br />
But trying to improve some reporting to utilize Excel &amp;&nbsp;Access 2007 to connect to this Pervasive SQL9 database.
</div>
</div>


Need to learn how to use my Pervasive SQL9 database and connect it via ODBC.

Trying to create excel reports and access 2007 to analysis our data from this database system.

Currently we are using Small Business Server 2003 using the Pervasive SQL9 software as our database for Magic eDeveloper 9.4 as our production system. Normally I retrieve data using Crystal Reports by using DDF files thru Betrieve connection.

But trying to improve some reporting to utilize Excel & Access 2007 to connect to this Pervasive SQL9 database.

How do I use my Pervasive Database system to help me with Excel reports?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Crystal Reports

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.