Hi Eric.

>or to access the database directly ?
>
>(Accpac advantage enterprise 5.3)

Sage Accpac can use one of several database engines, including Pervasive (formerly known as Btrieve), SQL Server, and DB2. Each of those has an ODBC driver you can use to access the data.

Accpac also has a built-in export function that can export certain sets of data (such as customers, invoices, etc.). However, I recommend accessing the database directly using ODBC because you don't have the limitations of the export function in that case, plus you can automate it using VFP, .Net, etc.

The only complexity is figuring out what tables contain the information you need. Let me know what you want to get at and I'll try to help you figure out what tables to get it from.

Doug