Xls file imported into mysql using php

[Serganator]

Hi everyone

i've been googleling for the past few days for and answer and some code. I'm trying to import and xls file into a mysql database using php. i'm able to import a cvs file but i'm trying to bypass to whole save as cvs process

if someone can point me in the right direction it would be great

thanks in advance

[stingwray]

Whats the reasoning behind bypassing saving to cvs?

Its that or having something convert the xls files into cvs at some point before loading, which adds another step and tool in the chain.

[xdmag]

Using Microsoft tools (such as ASP or VBScript) you can run SQL queries on an Excel sheet. If you are on a *nix/Linux server, maybe you can automate OpenOffice to convert the XLS into CSV then process the results.