mysqlimport csv file import problem - Jim Seymour - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlmysqlimport csv file import problem

From	Sent On	Attachments
Jim Seymour	26 Aug 2006 21:41
Thomas Spahni	28 Aug 2006 04:46
Jim Seymour	28 Aug 2006 08:40

Subject:	mysqlimport csv file import problem
From:	Jim Seymour (blue...@speedfactory.net)
Date:	08/26/2006 09:41:42 PM
List:	com.mysql.lists.mysql

Hi,

I download a csv file from Yahoo in this format:

ABIAX 20.63 2006-08-3 ACEIX 8.78 2006-08-3 CIGAX 10.08 2006-08-3 FSCTX 22.25 2006-08-3 GGOAX 20.55 2006-08-3 HWLAX 23.3 2006-08-3 HWMAX 28.74 2006-08-3 MLEIX 96.37 2006-08-3 NBPBX 18.98 2006-08-3 PSVIX 32.43 2006-08-3 PTRAX 10.3 2006-08-3 RGACX 30.89 2006-08-3 ^DJI 11242.6 2006-08-3 ^IXIC 2092.34 2006-08-3 ^GSPC 1280.27 2006-08-3

My table for this data is in this format

| 2006-08-02 | 20.72 | 8.81 | 10.08 | 22.19 | 20.48 | 23.19 | 28.52 | 96.21 | 18.87 | 32.14 | 10.31 | 30.95 | 11199.93 | 2078.81 | 1278.55 |

Is there a way to get mysqlimport to pull the data from specific column/row to insert into a specified field? Trying to find an easier way than typing all of the data into a text file for import.

Thanks,