Subject: Re: From Excel to MYSQL
From: Mike Mellor (mmellor1@yahoo.com)
Date: Wed Apr 24 2002 - 17:17:27 AKDT
Here's yet another way (I just learned to do it myself):
Save the Excel file out as a tab (or maybe comma) delimited file
Start mysql:
USE foo;
LOAD DATA LOCAL INFILE 'bar.txt' INTO TABLE foobar;
That should do it.
Here's the link I found helpful:
http://www.mysql.com/doc/L/O/LOAD_DATA.html
Mike
> Date: Tue, 23 Apr 2002 22:39:28 -0700 (PDT)
> From: Mehran <cf680@yahoo.com>
> Subject: From Excel to MYSQL
>
>
> Hi all:
> Is there any way I can transfer my Excel data to MYSQL
> on my Linux box, without typing in every single one of
> them.
>
> Regards
>
-- Attached file included as plaintext by Listar --
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE8x1ktXag/3k9wiGARAvm8AJ9+3jT4vAzEqcsXRs3cbk4RClTLOACfQqf0
DFzA2jvRHNnd0wjk7FBt/4g=
=CBwF
-----END PGP SIGNATURE-----
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
This archive was generated by hypermail 2a23 : Wed Apr 24 2002 - 17:17:48 AKDT