List:General Discussion« Previous MessageNext Message »
From:Steve Ruby Date:August 3 1999 4:25pm
Subject:Re: mysql and excel
View as plain text  

You can connect to Excel sheets with ODBC and connect to
Mysql with MyODBC you could then use access or other program
to link them together and transfer data.

Although it would probably be easier to dump the data to a text
file and use LOAD INFILE (see mysql manual)

On Tue, 3 Aug 1999, Stuart D Jackson wrote:

> 	Does anyone know of a script or program that will take an excel
> spreedsheet and turn it into a mysql database?  Thanks a lot.
> 
> -Stuart
> 
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread9221@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
> 
> 

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