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",
"-150.093943"
Where everything is in quotes and comma sep

Can someone tell me, how to rapidly import all this data into a table.
-- 
-------------------------------------------------------------
Scott Haneda                                Tel: 415.898.2602
<http://www.newgeo.com>                     Novato, CA U.S.A.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to