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
(probab
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
ta
