|
Posted by Rik Wasmus on 01/08/08 18:08
On Tue, 08 Jan 2008 19:02:57 +0100, Alan M Dunsmuir
<alan@moonrake.demon.co.uk> wrote:
> A client has sent me a (Windows) Excel Spreadsheet (.xls) file
> containing a block of data he wants included as a table in a MySQL
> database in a (Linux-based) PHP/MySQL Web application I'm developing for
> him.
>
> I have both Windows and Linux available on my own machine.
>
> What is the recommended route to get this .xls file into MySQL?
xls -> csv -> LOAD DATA INFILE
--
Rik Wasmus
Navigation:
[Reply to this message]
|