Serganator Posted February 25, 2009 Share Posted February 25, 2009 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 Quote Link to comment Share on other sites More sharing options...
stingwray Posted February 25, 2009 Share Posted February 25, 2009 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. Quote Link to comment Share on other sites More sharing options...
xdmag Posted February 25, 2009 Share Posted February 25, 2009 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.