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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
>
>
=====
---
Stefan Hinz <[EMAIL PROTECTED]>
iConnect e-commerce solutions GmbH, 13355 Berlin
Office: +49 30 46307-382 Mobil: +49 177 7841069
Antwortadresse dieser E-Mail: <[EMAIL PROTECTED]>
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/
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
