Many thanks to all
-
Do you Yahoo!?
All your favorites on one personal page Try My Yahoo!
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,
> >
> >
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
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
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
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 unde
You can create a odbc source for both and copy the data that way.
/Fredrik
"Daniel Berwig" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Is it possible to migrate data into a table in MS Excel to MySQL?
>
> Thanks in advance.
>
> Daniel Berwig
>
>
--
PHP
he MyODBC driver. 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
> &
TECTED]
> Subject: [PHP-DB] 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) som
