As suggested by David, save the excel file as CSV file then you can
insert the data into database through command like LOAD INFILE for MYSQL
with best wishes
balwant
On Tue, 2005-01-25 at 12:34, David Robley wrote:
On Tuesday 25 January 2005 08:07, Novice Learner wrote:
Hello,
I have
use LOAD DATA (plus parameters) to import excel-files and other
text-files into mysql
chris
Am Sonntag den, 30. Juni 2002, um 01:23, schrieb Manuel Lemos:
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
i forgot: LOAD DATA is a mysql-command
http://www.mysql.com/doc/L/o/Loading_tables.html
chris
Am Montag den, 1. Juli 2002, um 14:16, schrieb Christian Rellstab:
use LOAD DATA (plus parameters) to import excel-files and other
text-files into mysql
chris
Am Sonntag den, 30. Juni 2002,
] RE: Excel to MySQL
I do this fairly often (actually from MSSQL to Access to Excel to MySQL --
I'm sure there's a shorter route!)
I convert the Excel file to a tab delimited file. I do run into two
problems:
a) some of the text entries are surrounded by double quotes and
some aren't
(some
. On the www.mysql.com website I think.
Then you won't need CSV or any other type of import file.
Tony
-Original Message-
From: Mikusch, Rita [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 17, 2001 5:05 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] RE: Excel to MySQL