Hi,
We're trying to re-write a series of reports that we had in the Paradox version, that delivers info via Excel. We were planning on using a ODBC connection (unless someone can suggest something better).
We're looking for the database account…
The current situation :
We are using ODBC to pull data from the Sage 50 database to Excel. For example, if we pull the table taccount from the database we get the table with the GL accounts list and the amount at the present time. It produces a trial…
Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…