It looks like the tabs were changed as I sent the file. Either think of
each | as a tab, or use the DELIMITERS '|' on the COPY command.
Clinton
-----start import.head-----
0105|10102806|0001|20010328|12:25|0000841001|0001234567|SACRAMENTO|CA|0.6|00
0000000|0.0500
0105|10102806|0001|20010411|17:27|0000841001|0001234567|MT
VIEW|CA|0.7|000000000|0.0500
0105|10102806|0001|20010402|13:41|0000841287|0001234567|MT
VIEW|CA|0.7|000000000|0.0500
0105|10102806|0001|20010402|13:43|0000841287|0001234567|DENVER|CO|0.9|000000
000|0.0700
0105|10102806|0001|20010403|11:00|0000841287|0001234567|PLEASANTON|CA|1.0|00
0000000|0.0700
0105|10102806|0001|20010411|16:48|0000841287|0001234567|ROCKVL
CTR|NY|1.1|000000000|0.0800
0105|10102806|0001|20010411|16:51|0000841287|0001234567|ATLANTA|GA|0.7|00000
0000|0.0500
0105|10102806|0001|20010411|16:53|0000841287|0001234567|KENOSHA|WI|0.4|00000
0000|0.0300
0105|10102806|0001|20010411|16:55|0000841287|0001234567|LEAGUECITY|TX|0.8|00
0000000|0.0600
0105|10102806|0001|20010411|16:57|0000841287|0001234567|GREEN
BAY|WI|0.8|000000000|0.0600
-----end import.head-----