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
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
: trying to upload an excel
file into table
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]
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)
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
,
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
***
-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
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 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
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
11 matches
Mail list logo