Converting Excel Data To Be Inserted Into Mysql*

[robinwilson16]

Please can someone tell me how to do this

I am helping someone who has an excel file with the names and addresses of about 1 million companies and he wants it transfered into his mysql database which interfaces with his new php site with existing data already in

I thought about saving it as a comma delimited file and adding insert into at the beggining of each line but with a million entries was hoping there was an easier way

Thanks a lot

[Sephiroth]

there should be a way to do it using ODBC and VB, but as to how, good luck, i've no clue

[robinwilson16]

LOL ok thanks :P

Might have to stick to the comma dlimited option then find and replace in dreamweaver