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]
