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) leftmost columns of your data? If you do then you should definitely consider normalizing. A table with several hundred (let alone a thousand) columns, while possible, will be rather clumsy to deal with.
If I can be curious: What was the source of this data? Do you already have this data in any other format? What environment are you working in? What version of MySQL are you running? How good are your scripting skills? How much Excel experience do you have? Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine [EMAIL PROTECTED] rutgers.edu To: [EMAIL PROTECTED] cc: 07/12/2004 01:47 Fax to: PM Subject: trying to upload an excel file into table Hello, I am a newbie to mysql and have one major task to accomplish in order perform my duties. I have a few excel files that have a few hundred to a thousand columns, with each column consisting of a title/category, and thousands of bits of information (decimals) under each category. What i want to do is have each column heading become a field, and all the info under that heading become information in that field. Is there a way to set up my tables so I do not have to manually type in each field name? Otherwise, it is too long and tedious to type each field name by hand. Thanks Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]