Using the Windows XP 2002 Professional Operating System with Service Pack 2 (SP2)
Note: Participants must return local Address Lists and Address Count Lists in the predefined, pipe-delimited ASCII text file format specified by the Census Bureau.

Summary: This document covers:
• Setting the pipe symbol as the default delimiter
• Converting a computer-readable predefined pipe-delimited ASCII text file into MS
Access database
• Importing Address List or Address Count List Set the Pipe Symbol as the Default Delimiter
1. From the Microsoft (MS) Start button on the MS Windows task bar, highlight Settings and select the Control Panel. In the Control Panel window select Regional and Language Options.
2. In the Regional and Language Options window, select the Regional Options tab, click the Customize… button.
3. In the Customize Regional Options window, select the Numbers tab.
4. Set the List Separator field to a pipe-delimited symbol | by pressing Shift and |

Download pdf Converting Pipe-Delimited ASCII Text Files into Microsoft Access 2002