In this walkthrough you will learn how to create a dataport that can be used to export data as well as import data. The dataport can update prices in the Item table in an external program such as Microsoft Office Excel.

Expand imageAbout This Walkthrough

To create a dataport

  1. Click Tools, and then click Object Designer.

  2. In Object Designer, click Dataport, and then click New.

  3. In the Properties window for the new dataport, set the following properties.

    In this walkthrough, the format of the external file is variable and uses a semicolon as the field separator. This is because the external editor is Microsoft Excel, and for this use, a .csv file is appropriate.

You have created a dataport and must now specify which tables and fields will be used in the dataport.

Expand imageEnabling the Dataport to Export Data

Expand imageEnabling the Dataport to Import Data

Expand imageTesting the Dynamic Dataport

Expand imageNext Steps

Expand imageSee Also