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.

Reply to this topic