Can I import data from csv files?
Yes, you can. To do it, you should do the following: • Select Start->Settings->Control Panel->Administrative Tools->Data Sources(ODBC). • Click the «Add» button. Select «Microsoft Text Driver (*.txt, *.csv)» • Click «Finish». In the next window fill in the «Data Source Name» field, for example, type «Original data». Clear the «Use current directory» checkbox, click «Select Directory» and select the folder where your CSV files are located. • Click the «Options» button. Select *.csv in the «Extensions List». • Click the «Define Formats» button. Select the necessary file in the list, for example, file1.csv. If your file contains column names (the first string in the file), you should select the «Column Name Header» checkbox. Choose a delimiter. Usually it’s a semicolon. In this case you should select «Custom Delimited» in the «Format», and type a semicolon in the «Delimiter» field. If you used another delimiter, type it in the «Delimiter» field. Select the ANSI or OEM encoding. If the CSV
