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
Many thanks to all
-
Do you Yahoo!?
All your favorites on one personal page Try My Yahoo!
On Tuesday 25 January 2005 08:07, Novice Learner wrote:
Hello,
I have an Excel worksheet with a database in it. I would like to move this
data to the database on the server that would work with my .php files.
Is there a way?
I apologize if I posted this question on the wrong list.
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,
Hello,
On 06/29/2002 06:21 PM, Chase wrote:
Does anyone know of a way that I can export an Excel spreadsheet to a
file that I can import to MySQL? I found a program that will do this
for Access, but I would rather leave Access out of this if possible.
I think you can do it via ODBC under
] 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