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

RE: trying to upload an excel file into table

2004-07-12 Thread Victor Pendleton
into a 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

Re: trying to upload an excel file into table

2004-07-12 Thread SGreen
: trying to upload an excel file into table

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]

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)

RE: Query and export to a Excel file

2002-10-29 Thread Andrew Braithwaite
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 - Before posting, please check

RE: Query and export to a Excel file

2002-10-29 Thread Andrew Braithwaite
, 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 file into a tab delimited text file

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: 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 fine I

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 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 choose the right column