>Thanks for your help guys, basically they gave me the option to choose. I'm thinking fixed length text file would be ideal but just wanted to know what other people thought.
Fixed length (SDF) is a good choice. On some occasions I've found that delimited formats cause problems e.g. sometimes character strings are quoted, sometimes not, then there's the handling of quotes within quoted strings, or delimiters within strings etc.
Besides issues that others have mentioned Excel can be limited to (I think) either 16K or 64K rows, depending on version, which could be a problem with lots of data. As the saying goes, EINAFD < g >
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up