Summary
How to export data from Sage 300 CRE to Excel using the Timberline Data Source.
Resolution
- Verify that you created the Timberline Data Source for the correct data folder.
- In Excel, click the Data tab.
- Click From other Sources and choose From Data Connection Wizard.
- Select ODBC DSN and click Next.
- Select the Timberline Data Source or the DSN you created and click Next.
- Enter in your Sage 300 CRE Username and Password.
- Select the table you want to export from the list and click Next.
- Click Finish on the Save Data Connection File and Finish window.
- Click OK on the Import Data window if the settings are fine.
- Enter in your Sage 300 CRE Username and Password.