Please can someone tell me how to do this :huh:

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 :o

Thanks a lot B)

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

LOL ok thanks :P

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