Because of its simplicity, the CSV format is often used by applications to store data in a tabular structure. The simplicity of the format also determines its drawbacks - in general, it is not known in what encoding the data is stored in a particular csv file, what are the used column separators, text delimiters. But what if you need to open a csv file and view the data contained in it?
Necessary
installed Microsoft Office Access
Instructions
Step 1
Create a new database in Microsoft Office Access into which the information from the CSV file will be placed for later viewing. Select the menu items "File" and "New" and click on the link "New database …" in the panel that appears. The "New Database File" dialog will be displayed. Select the directory for saving and the name of the database file in it. Click the Create button.
Step 2
Begin the process of loading data from a file. In the menu, select the items "External data" and "Import …". In the drop-down list "Files of type" of the "Import" dialog that appears, select "Text files". Go to the directory with the CSV file, select it in the directory listing, click the "Import" button. The "Import Text" wizard appears.
Step 3
Define the format properties of the data to be imported from the CSV file. Click the Advanced button. In the "… - import specification" dialog specify the field format type, field separators, time, date, parts of decimal numbers, as well as the date format, text delimiter character and text encoding. Click OK. Click "Next".
Step 4
Specify the rules for interpreting the data on the first line of the file. On the second page of the wizard, select the "First line contains field names" check box if necessary. Navigate based on the contents of the list, which displays the first few lines of the file. Click "Next".
Step 5
Check the "in a new table" option. Click "Next".
Step 6
Determine the names of the columns and the format of the data they contain, if necessary. On the fourth page of the wizard, click on the required column of the list in which the file contents are previewed, enter its new name in the “field name” text box and select a format from the “data type” drop-down list. Click "Next".
Step 7
Select the option "do not create a key". Click "Next".
Step 8
Enter a convenient name in the "Import to Table" field. Click "Next". Wait for the import process to finish.
Step 9
Open the data from the CSV file. Click on the "Tables" tab. Double click on the list item with the name specified in the previous step. Review the data.