excel spreadsheet

[aviendha]

I think this might be a stupid question, but I can't get the answer anywhere. If I have an excel spreadsheet, can I just save the whole thing in a MySql table? I don't mean just the data, I mean the actual sheet.

Thanks.

[schmalenegger]

Hi,

At first you should save your excel sheet as a csv-file!
That means that all values will be seperates in a file with commas (csv = comma seperated values).
Now you can import this csv-file to your mysql-database.
The easiest way is to use a tool like phpmyadmin or something like that, but if you can also make a query like this:

mysql> LOAD DATA INFILE "/tmp/file_name" INTO TABLE test IGNORE 1 LINES;

For a better explanation see:
http://www.mysql.com/doc/en/LOAD_DATA.html

Hope this helps