making a sql database from an ms excel file

If you are using mysql all you have to do is save the excel as a .csv file and it can then be imported into mysql.

Cd&

Cobol and other responders,


  I tried do as you say, first Excel says that my file "may not contain features that are compatible with csv"  secondly, when I save it anyway as a csv and try to import it into PHPMyAdmin, I get an error saying the file is too large.  What should I do now?

The file is less than 3mb, ughh this is annoying.  There has to be a way to do this without going to great lengths.

I broke it up and now i get the error:  "#2006: MySQL server has gone away"  what is that about?  I am using WAMP 2.2

It should be easier, but it's not. MS creates as many barriers to open source as it can.  I have to assume the conversions are problematic because A converter like this sells for a hundred bucks.

I don't know if it is worth that much, but the fact that they can sell such a thing probably indicates that you are not going to have an easy time of it.

Cd&

There are a bunch of ways to get that error.  It appears a lot of it is caused by windows.

Here is the mysql manual page


Cd&

The manual was of no help.  Anybody else got a suggestion or can do it and just send me the sql file?  Thanks