...
- Original data type: Delimited
- Start Import at row: 1
- File origin: 20127: US-ASCII
Click Next
...
Step 2
Use the following settings:
- Delimiters: Tab (with Tab Delimited files. Other file types and delimiters will vary)
- Text qualifier: " You may need to change this. Check the Data preview at the bottom of the screen. The lines represent columns in an Excel file. If the text is displaying properly, leave the Text qualifer field as-is. If the text in each column is not displaying properly, choose a text qualifier from the pull down menu until the text in columns displays in the correct fashion. #Click
Click Next
Step 3
Use the following settings:
- Column data format: Text
The default import format is General. This will convert numeric values to numbers, date values to dates, and remaining values to text. This is a problem when importing GPS latitude/longitude points or long identifier strings from Census data, because the General format will convert the values in these columns to scientific notations. To make sure Excel imports all columns as Text, do the following:
...