loading data into a table from excel spreadsheet

[Pindz]

Hello,

I have a excel spreadsheet from which I would like to load data into a
table in mysql.
Can you please give me an example of the above.

Thanks in advance

Nagsy

[Bill Karwin]

Pindz wrote:

Hello,

I have a excel spreadsheet from which I would like to load data into a
table in mysql.
Can you please give me an example of the above.

I've been doing this recently in Perl by reading the spreadsheet with
the Spreadsheet::ParseExcel module, and then connect to the database and
insert records for each row in the spreadsheet, using DBD::mysql.

You can also save the spreadsheet as a text file (under the "Save As..."
menu, you can specify file type as CSV), and use MySQL's mysqlimport
utility.
http://dev.mysql.com/doc/mysql/en/mysqlimport.html

Regards,
Bill K.

[Scott]

na******@hotmail.com (Pindz) wrote in message news:<a6**************************@posting.google. com>...

Hello,

I have a excel spreadsheet from which I would like to load data into a
table in mysql.
Can you please give me an example of the above.

Thanks in advance

Nagsy

NAGSY:
I'm only a novice, but this is how I do it, and it works well for me:

1) Save the Excel spreadsheet (just the sheet, not the whole Excel
workbook) as a tab delimited text file.

2) Copy the text file

3) Past it into a SQL window of MySQL Control Center & click on the
exclamation mark

The more knowledgable database experts on this board can probably tell
you a better way, but in meantime, the above actually works.