Set Up an ODBC Data Source

Home | FAQs & Troubleshooting

 

Expand/Collapse all Show/Hide All

Export to an ODBC Data Source

Set up the File Receiving the Data

Set Up an ODBC Data Source

Perform the Export to the ODBC Data Source

 

Expand/Collapse item  Overview

This is the second of three procedures needed to export to an ODBC data source.

 

To set up an ODBC data source

  1. On the Windows Start menu, click Settings and then click Control Panel.

  2. In the Control Panel window, access the ODBC Data Source Administrator.

  3. On the ODBC Data Source Administrator User DSN tab, verify that your data source is already created. You can select an existing data source and click Configure to verify that it is properly configured to access the data you want. For one-time access of Excel and Access files, you can select the default data source and change the configuration to access a specific data file.

    If you are using Sage 100 Advanced and want to access a data source that resides on the server (host) system, and the system is running as a service on the server, you must create a data source on the System DSN tab. You cannot access any data source defined as a User DSN on the server.

  4. To create a new data source, click Add and select the ODBC driver in the Create New Data Source dialog box. Click Finish, and the ODBC Setup dialog box specific to the selected driver appears.

  5. In the ODBC Setup dialog box, enter the information requested to specify the location and name of the data files to access.

Note If you intend to write to an Excel file, click Options and clear the Read Only check box.

  1. Exit the ODBC Data Source Administration window.

  2. Complete the procedure, Perform the Export to an ODBC Data Source.