| **Navigation:**  [[welcome to my product .htm|User's Guide and Tutorials]] > Getting Started with Clarion! >====== Exercise Two - Import Your Data ====== | [[exercise one create the dictionary.htm|{{btn_prev_n.gif|Previous page}}]][[welcome to my product .htm|{{btn_home_n.gif|Return to chapter overview}}]][[exercise three relate your tables.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

1.If you haven't done so already, maximize your dictionary window. It's not much to look at right now, so let's import some data definitions. In the //GettingStarted// folder, we have placed some sample data files. In this exercise, we will import a set of //customers//, and their //orders//.

2.From the DCT Explorer's toolbar menu, choose the **Import Tables **option as shown here:

{{gsl2a.jpg|GSL2A.jpg}}

The //Table Import Wizard// window appears.

3.In the **Select Server** prompt, select //TopSpeed// //Files// from the drop list (It's at the bottom of the drop list). At the time of this release, there are 15 different import formats available for import in the drop list.

4.Select the **Select Dictionary** prompt, and press the **ellipsis** button (you can also press the **Next** button at the bottom). The //Select Database// window appears.

{{gsl2b.jpg|GSL2B.jpg}}

5.Press the ellipsis button to the right of the **Files** prompt.

6.Another //Select Files// window appears, but this time it is a file dialog where you can select a file name. Navigate to the \Lessons\GettingStarted folder, and holding your CTRL key down, highlight the CUSTOMER.TPS file (The TPS is the TopSpeed default file extension) and the ORDERS.TPS and press the **Open** button.

7.We are now back at the original //Select Database// window. Press the **OK** button to begin to import the files.

8.The DCT Explorer displays your imported tables.

{{afterimport.jpg|AfterImport.jpg}}

That's the basics for a file import. Of course, there are many other options and techniques that you can use to import data definitions, but we are only getting started.

To review, the dictionary will be used with the application generator to help match and locate the data that we are planning to process.

{{gse1l2.jpg|GSE1L2.jpg}}

At this time, your dictionary is auto-saved after the import, so let's proceed to Exercise Three.

[[exercise three relate your tables.htm|Exercise Three - Relate Your Tables]]