From: Date: August 3 2001 10:48am
Subject: Re: How to add an excel file directly to MySQL database using PHP?
List-Archive: http://lists.mysql.com/mysql/81507
Message-Id: <20010803084815.43109.qmail@web9607.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Dear Yeong,

> How can I add an excel file with *.xls extension

AFAIK you will have to save the Excel sheet as a CSV file. You need to
save every single sheet as CSV, but you can automate this with an Excel
macro.

Make sure you know the field separators (usually tab characters) and
line separators (usually \n, sometimes a problem between Windows and
Unix, in this case: Save the CSV file(s) with Unix format).

LOAD DATA INFILE should work fine then, if not, check the separators
again and set them accordingly (options for LOAD DATA).

Regards,

--- Yeong CN <tzeen@stripped> wrote:
> How can I add an excel file with *.xls extension
> directly into MySQL database..is it possible to do or
> I need to convert it into *.csv format or *.txt format
> first?
> 
> 
> 
> Get 250 color business cards for FREE!
> http://businesscards.lycos.com/vp/fastpath/
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread81486@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-hinz=js-webshop.com@stripped>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> 
> 
> 


=====
---
Stefan Hinz <hinz@stripped>
iConnect e-commerce solutions GmbH, 13355 Berlin
Office: +49 30 46307-382  Mobil: +49 177 7841069
Antwortadresse dieser E-Mail: <hinz_stefan@stripped>
BITTE NUR IN DRINGENDEN FÄLLEN AN DIESE ADRESSE ANTWORTEN!
---

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/