My client has given me data in the form as an Excel spreadsheet and wants the contents ov it to be inserted into a sql datbase.

Is there any programs about or anyways i can insert the data automatically into the database?

Thanx

Jonathan

    This really should be in the database forum (really, that's what it's there for), but the easiest way to do this is to save the file as a comma-delimited file (.csv) and then import it into your database. In MySQL this can be accomplished with relative ease using the LOAD DATA INFILE command. If your database of choice doesn't have a comparable command, it should be pretty trivial to write a PHP script to do it for you, line by line.

      You can also genarate a SQL Script by writing a SQL command in a EXCEL formula like: ="INSERT INTO table_name (Field1, Field2) VALUES ('"&A1&"',"&A2&") go"

      Copy - paste the formula and execute it in your DB....

      Christophe TOGNETTI
      http://www.realscale.com

        Write a Reply...