Import Data WizardUsing the Import Data wizard you can import data from another database as long as your data are written in a text file. There are many ways to enter data into text files. See the example below: "Last Name","First Name","Company","Street","City","Country" "Johnson","Rick","Advanced Communications","10235 Panorama Ave","Portland OR 97233","USA" "Smith","George","HLS Designs","28935 Baker St","Sacramento 95820","USA" Note that this inscription consists of three lines and that the first one contains column names. The character which distinguishes data is called a delimiter. In this example the role of the delimiter is taken by the comma (,). The quotation mark ("), in this case, is a character which we shall call a text qualifier. When you activate the Import Data Wizard you will get a window as in the figure below:
 Database file If you have already defined the databases in the program, its path will stand in the 'Database file' text box. If not, you should click the 'Browse' button and locate the database file whereto you would like to import the data. Import file The Import file text box is supposed to contain the path to the text file which contains data. Click the 'Browse' button and locate the file that contains the data you need to import. Click the 'Next' button to continue. 
Now we should define the format wherein your data were put in. The first couple of lines of your text will be displayed in the text box at the bottom of the screen, so that you would be able to precisely evaluate the delimiter and the quantifier in your particular case. If your data are arranged like this: atm@hotmal.com hans@peoas.net 2u@gate.co.uk In this case the delimiter is the new row behind each e-mail address in turn. How shall we enter this datum into the Wizard? Click the option box 'Other', then click the empty text box at the right. Press 'Enter' on your keyboard. You have just entered a new row into the text box and made the program aware that, in this e-mail case, your data is distinguished by a new line. First Row Contains Field Names Select the 'First Row Contains Field Names' checkbox if the first line in your text contains column names. Thanks to this, the program will automatically name the import columns. Click the 'Next' button. 
Store data in a new table When selecting this option make sure that you enter the name of your column to the space on the right. You will get a chance to define columns within your new table after you have clicked the Next button. Store data in an existing table If you select this option, select the table name whereto you want to import data from the combo box to the right. The program will import data into the selected, existing table. Click the 'Next' button. 
If you had selected the 'First Row Contains Field Names' checkbox at step 2 of the wizard, when defining delimiters and qualifiers your column names will be displayed at the left bottom part of the screen. If you cannot see column names you will have to enter them. Enter the column name into the Field Name text box and click the Add button. Bear in mind that if the following data appear in your text file: "Johnson","Rick","Advanced Communications" "Smith","George","HLS Designs" Probably give these names to your columns: Last Name First Name Company Mind that the columns must stand in the list in the same pattern as they were defined in the import text file. Click the 'Next' button: 
In this section of the wizard we should make the program aware which column from the import text file coincides with one of your table database columns. All database columns will be displayed to the left, whereas all text file columns pre-defined at Step 4 will be displayed to the right. In order to set up the program successfully you should put the identically named columns on the left within the same plane as those on the right. For example, in such a way you will click the City column at the left using the up and down arrows which can be found at the bottom of the screen and move the inscription until it coincides with the City column at the right. Do likewise with other columns as well. Click the 'Next' button. 
At this Wizard step you will have the opportunity to filtrate the import data. You may define an infinite number of conditions. FILTERS Adding a new filter In order to define a new filter, click the Add button. A window like the one below will open up: 
The filter is defined by selecting a column from the first combo box i.e. the one wherein the program would be looking for keywords defined by yourself within the corresponding text box. Search Criteria Equals The program will select only those column values which fully correspond to the defined keywords. Contains The program selects column values if it contains keywords in any text section. Starts with The program will select values if they start with defined keywords. Ends with The program will select values if they end with defined keywords. ------------------------------------------ Include Type Use this option to select only those records which fulfill the given condition. The action (delete, select, new table) would encompass only those records that satisfy this condition. Exclude Type Use this option to select only those records that DO NOT satisfy the given condition. The action (delete, select, new table) would encompass only those records that DO NOT satisfy this condition. Export Data Wizard See Also: E-mail Merge Extracting data from the web forms Mail Server Execute CGI Message Tags Execute Program Message Tags Scheduler | 
