transfer excel file to DB

[atamel]

Hi,

I have an excel file that contains the following information about around 5000 people.

Lastname, FirstName, Row#, Column#, BirthDay, Age.

I want to transfer the information in this excel file to a database. But obviously I don't want to do it manually. I'm wondering if someone has a script that I can use to do this.

What I would exactly want to do is the following. I want to read one row (line) of the excel file, produce the SQL statement (INSERT INTO...) and insert that information in the DB, and then go on to the next row until all rows are inserted into the DB. Or maybe someone has a better way of doing this.

Thanks a lot!
Mete

[LordShryku]

You got a couple choices:

1) Use Access to ODBC link to your database. Import the document, copy, paste.
2) Save it as a comma delimeted file, and use LOAD DATA INFILE
3) Google for "Excel to SQL"