You can use a programming language to read the first line of the files and
create a DDL statement for you. But MySQL will not do this natively. I am
not certain but I think you may be able to use Visual Basic and the excel
DOM to perform the entire process. Or you can just export the data into a
David,
This sounds vaguely like a normalization issue as well. If your data
consists of one or more identifying columns and the rest the columns
exist data as explanatory data then you should probably think about
scripting an import routine. Do you see repetitive blocks of data in the
(probably)