Actually, if it's comma separated, and strings are quote-delimited, you don't even need DELIMITED BY ..., you just need the word DELIMITED.
But as Michel says, you CAN'T do append without figuring out the table layout you need to append into first.
>Isn't APPEND FROM ... DELIMITED BY .... what you want ?
>
>Regardless of what you use, however, you WILL need to have some idea
>of [fields, type, and length].
>
>>[...] I want to get a comma seperated file in a table. I don't know the lengths of the fields coming in so I can't predefine a table to put them into.
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing