Re: From Excel to MYSQL


Subject: Re: From Excel to MYSQL
gkvokov@ieee.org
Date: Wed Apr 24 2002 - 16:33:00 AKDT


phpMyAdmin is a web interface to MySQL and has an option where you can insert
text files into databases. It gives you a bunch of options to work with as to
the format of the text file.
Greg

At Wed, 24 Apr 2002 12:50:25 -0800, you wrote
>
>And yet another solution...
>
>Save the Excel file as a CVS file, and then load that in via the MySQL
>command to import text. Forget what it is off the top of my head, but you
>could check the Docs.
>
>j----- k-----
>
>On Tuesday 23 April 2002 21:39, Mehran wrote:
>> 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.
>
>--
>Joshua Kugler, Information Services Director
>Associated Students of the University of Alaska Fairbanks
>isd@asuaf.org, 907-474-7601
>
>---------
>To unsubscribe, send email to <aklug-request@aklug.org>
>with 'unsubscribe' in the message body.
>

---------
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 - 16:33:08 AKDT