List:General Discussion« Previous MessageNext Message »
From:Ralph Graulich Date:August 3 1999 8:14pm
Subject:Re: mysql and excel
View as plain text  
Hi,

>	Does anyone know of a script or program that will take an excel
> spreedsheet and turn it into a mysql database?  Thanks a lot.

You can save your excel spreadsheets in a tab delimited format file. Both
the excel versions for windows and for the macintosh are capable of doing
this task. When using a macintosh you should use the "recode" command on
unix to get the charsets converted right for directly importing the data
with

  LOAD DATA INFILE 'tabsep.file' FIELDS TERMINATED BY '\t'  etc. etc...

into mySQL. The correct light for using recode from mac to latin1 charset
would be

  recode macintosh:latin1 mac-tab-sep-file > latin1-tab-sep-file


Regards
... Ralph ...


-----------------------------------------------------------
Ralph Graulich, Hasengrund 22, 77654 Offenburg, - GERMANY -
-----------------------------------------------------------
Tel    +49 781 41517 (priv.)      +49 781 504 4003 (office)
Fax    +49 781 41518 (priv.)      +49 781 504 4099 (office)

private homepage            http://graulich.baden-online.de
thoroughbred stud Karlshof          http://www.karlshof.com
horse breeding pages                 http://www.gestuete.de
-----------------------------------------------------------


Thread
mysql and excelStuart D Jackson3 Aug
  • Re: mysql and excelSteve Ruby3 Aug
  • RE: mysql and excelMichael Robinson3 Aug
    • mysql and excelFRed3 Aug
    • RE: mysql vs. text fileEe Loon3 Aug
      • Re: mysql vs. text fileChristian Mack3 Aug
      • RE: mysql vs. text fileKelly Yancey4 Aug
        • Re: mysql vs. text fileMartin Ramsch4 Aug
          • Re: mysql vs. text fileSteve Edberg4 Aug
            • PHP as CGI script (was: mysql vs. text file)Martin Ramsch4 Aug
              • RE: PHP as CGI script (was: mysql vs. text file)Kelly Yancey4 Aug
                • Locking problem?Arlen Greer4 Aug
                  • Re: Locking problem?Patrick Sherrill4 Aug
                    • RE: Locking problem?Arlen Greer5 Aug
                      • Re: Locking problem?Christian Mack5 Aug
RE: mysql and excelWilliam D. Webber3 Aug
Re: mysql and excelRalph Graulich4 Aug
RE: Locking problem?Quentin Bennett5 Aug