List:General Discussion« Previous MessageNext Message »
From:Marc Antony Vose Date:March 7 2000 6:44am
Subject:getting data into mysql
View as plain text  
a really silly question, but...

how best to get a bunch of data from an excel spreadsheet into mysql?

some of the fields contain return characters, which sort of screw up 
a save as text dump.

is there some secret to this or is just massaging the text file the 
best way to import?

Marc Antony Vose
http://www.suzerain.com/

Can you look out the window without your shadow getting in the way?
-- Sarah McLachlan
Thread
[info@eternalsounds.com: FW: DSS SUPPORT:Small Database problem with Supermall]System Administrator a.k.a. The Root of the Problem28 Feb
  • Re: [info@eternalsounds.com: FW: DSS SUPPORT:Small Database problem with Supermall]sasha28 Feb
  • getting data into mysqlMarc Antony Vose7 Mar
    • Re: getting data into mysqlsinisa7 Mar
      • Re: getting data into mysqlMarc Antony Vose15 Mar
        • Re: getting data into mysqlsinisa15 Mar