Can anyone help me with this.

Here is what I'm trying to do.
Table A contains 'X' number of fields and my text file contain 'X' number of fields. I want to import the data in the text file to the records that it matches in Table A (3 fields in the text file = 3 fields in the table), and for the records that have no match, it will add a new record to the table. How can I do this with mysqlman or with a mysql command.
Thanks for your help.

See:

http://www.mysql.com/doc/L/O/LOAD_DATA.html

for the sql command that will do the trick.

Cheers,

Alex
--
Gossamer Threads Inc.