How to open csv file

Because of its simplicity the CSV format is often used by applications to store data in tabular structures. The simplicity of the format and identifies its shortcomings - in the General case it is unknown which encoding is used to stored the data in that csv file, what are used delimiters of the columns, the constraints of the text. But what if you need to open csv file to view the data contained in it?

You will need

• - installed Microsoft Office Access.

Instruction

1. Create a new database in Microsoft Office Access, which will be placed in information from a CSV file for later viewing. Select the menu items "File" and "new" and click "New database..." in the appeared panel. Dialog appears "File new database". Select the target folder and file name database. Click "Create".
2. Start the process of loading data from a file. In the menu select "get External data" and "Import...". In the drop-down list of "file Type" appeared dialogue "Import", select "Text files". Navigate to the directory with a CSV file, select it in the directory listing, click the "Import" button. Displays the wizard window "text Import".
3. Define the format properties of the data imported from the CSV file. Click "Advanced". In the dialogue "...the import specification" specify the type of field format, field delimiter characters, the time, date, parts of decimal numbers and the format of the date, symbol, text qualifier, and encoding text. Press the OK button. Click "Next".
4. Specify the rules of interpretation of the data of the first line of the file. On the second page of the wizard, select the check box "First row contains field names" if necessary. Focus on content-based list, which displays the first few lines of the file. Click "Next".
5. Select "new table". Click "Next".
6. Define the column names and format data contained therein, if necessary. On the fourth page of the wizard, click on the desired column list where you can preview the file content, type the new name in the text field "field name" and select a format from the drop-down list "data type". Click "Next".
7. Select the option "do not generate key". Click "Next".
8. Enter a convenient name in the "Import to table". Click "Next". Wait for the import process.
9. Open data from a CSV file. Click on the tab "Tables". Double click on the list element with the name specified in the previous step. Review the details.