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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement