Re: trying to upload an excel file into table

2004-07-12 Thread SGreen
PM Subject: trying to upload an ex

RE: trying to upload an excel file into table

2004-07-12 Thread Victor Pendleton
tab or csv or some other limited format and import using MySQL load data or mysqlimport. -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 7/12/04 12:47 PM Subject: trying to upload an excel file into table Hello, I am a newbie to mysql and have one major task to

trying to upload an excel file into table

2004-07-12 Thread davidtis
Hello, I am a newbie to mysql and have one major task to accomplish in order perform my duties. I have a few excel files that have a few hundred to a thousand columns, with each column consisting of a title/category, and thousands of bits of information (decimals) under each category. What i

Re: Excel file

2004-04-07 Thread mysql-support
Please read the attached file. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Query and export to a Excel file

2002-10-29 Thread Fernando Grijalba
*** -Original Message- From: Ma, Billy [mailto:bma@;go2uti.com] Sent: October 29, 2002 04:41 To: [EMAIL PROTECTED] Subject: Query and export to a Excel file hi all, my problem is, do you know how can i query and export a file in Excel format except use third parties software. regards, Billy

RE: Query and export to a Excel file

2002-10-29 Thread Andrew Braithwaite
at once - sorry!) Andrew, Sql,query -Original Message- From: Andrew Braithwaite Sent: Tue 29 October 2002 09:58 To: 'Ma, Billy'; [EMAIL PROTECTED] Subject: RE: Query and export to a Excel file Hi, You can use mysqldump (http://www.mysql.com/doc/en/mysqldump.html) to dump the

RE: Query and export to a Excel file

2002-10-29 Thread Andrew Braithwaite
: [EMAIL PROTECTED] Subject: Query and export to a Excel file hi all, my problem is, do you know how can i query and export a file in Excel format except use third parties software. regards, Billy - Before posting, please

Query and export to a Excel file

2002-10-29 Thread Ma, Billy
hi all, my problem is, do you know how can i query and export a file in Excel format except use third parties software. regards, Billy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http:

Re: How to add an excel file directly to MySQL database using PHP?

2001-08-03 Thread Werner Stuerenburg
Yeong CN schrieb am Freitag, 3. August 2001, 06:43:11: > 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? You can put anything into MySQL provided you choo

How to add an excel file directly to MySQL database using PHP?

2001-08-03 Thread Yeong CN
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

RE: How to add an excel file directly to MySQL database using PHP?

2001-08-03 Thread Adam Douglas
Well you have a couple options, you could export the Excel file to a delimited text file and then import into MySQL. You could also just use the Excel file and import directly into MySQL with the use of MyODBC and MS Access. That's all I can think of right now. Either way would work f

Re: How to add an excel file directly to MySQL database using PHP?

2001-08-03 Thread Stefan Hinz
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 l