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
tab or csv or some other limited format and import using MySQL load data or
mysqlimport.
-----Original Message-----
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 7/12/04 12:47 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]
