Re: Importing large data sets

2006-07-13 Thread sheeri kritzer
On 6/22/06, Scott Haneda <[EMAIL PROTECTED]> wrote: I have two chunks of data to import, one is in this format: "01001 - AGAWAM, MA","01001",0,0,291,249,0,"42.070206","-72.622739" Where it is comma sep and partially quoted The other is in this format "99502 ANCHORAGE, AK","256","265","1424","196

Re: Importing large data sets

2006-06-22 Thread Karl Larsen
Scott Haneda wrote: I have two chunks of data to import, one is in this format: "01001 - AGAWAM, MA","01001",0,0,291,249,0,"42.070206","-72.622739" Where it is comma sep and partially quoted The other is in this format "99502 ANCHORAGE, AK","256","265","1424","1962","1131","528","643","6209","9

Importing large data sets

2006-06-22 Thread Scott Haneda
I have two chunks of data to import, one is in this format: "01001 - AGAWAM, MA","01001",0,0,291,249,0,"42.070206","-72.622739" Where it is comma sep and partially quoted The other is in this format "99502 ANCHORAGE, AK","256","265","1424","1962","1131","528","643","6209","99502","61.096163", "-1