Tuto WEBDEV 25

82 Part 2: My first database Importing a CSV file A different method will be used to create the "PaymentMode" data file, which contains the payment characteristics: importing a CSV file. Remark A CSV file is a text file that is using a specific format. This file contains data on each line. The data is separated by a separation character (a comma, a semi- colon or a tab in most cases). From the CSV file containing the data, WEBDEV will create: • the description of data file in the analysis, • the HFSQL data file with the data found in the CSV file. ▶ To import a CSV file into the analysis: 1.  In the ribbon, in the "Analysis" pane, in the "Creation" group, expand "Import" and select "Import the descriptions of files/tables". Tip To import a CSV file (or any other file) into the analysis, you also have the ability to Drag and Drop the CSV file (from the Windows explorer) to the data model editor. This will be presented in the next paragraph. 2.  The wizard for importing a file starts. 3. Go to the next step. 4. Select the format of the data file to import. Here, select "Text file". Go to the next step of the wizard.