Forums
This topic is locked
excel to sql
Posted 12 Nov 2006 22:39:04
1
has voted
12 Nov 2006 22:39:04 bill triplett posted:
How do I convert excel to sql? Replies
Replied 06 Dec 2006 18:51:32
06 Dec 2006 18:51:32 Alan C replied:
You could convert the spreadsheet layout to a table in mysql, so you would have one record for each row then one field for each column
However - you would have to look at the data in each column and make sure that the field were the right type to hold that data, plus you would also need to look at the logical arrangement of the data because there may be repeating items that would be better held in different tables.
It's not an easy question to answer - it's rather open ended.
However - you would have to look at the data in each column and make sure that the field were the right type to hold that data, plus you would also need to look at the logical arrangement of the data because there may be repeating items that would be better held in different tables.
It's not an easy question to answer - it's rather open ended.