Viewing Exported Data
You can view files exported as a CSV file, an Access database, an ODBC database, as an Excel file, and in XML format. Depending on the Sage 300 form you are in when you do the export, there may be one or more sets of data exported. For example:
- If you export from the Currency Rates form into Excel, two Excel worksheets will be created in one workbook (for example, Currency_Rates and Currency_Tables in the workbook file, curr-rates.XLS).
- If you export from Currency Rates into an Access database, two tables will be created in the same database (for example, Currency_Rates and Currency_Tables in the database, curr-rates.MDB).
- If you export in CSV format from Currency Rates, two separate files will be created (for example, currency_rates.CSV and currency_tables.CSV).
To continue our Currency Rates export example, a title line with the following labels appears in each exported file for currency tables data:
| Field Label | Description |
|---|---|
| HOMECUR |
Home Currency |
| RATETYPE | Rate Type |
| TABLEDESC | Table Description |
| DATEMATCH | Date Matching |
| RATEOPER | Rate Operator |
| RATESOURCE | Rate Source |
Each field in the title line is a column displaying the values exported for that field.
Note that before exporting data from Sage 300, you must create Access and ODBC databases, an Excel file, and determine paths for CSV and XML exports.