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

Can you look out the window without your shadow getting in the way?
-- Sarah McLachlan
[ FW: DSS SUPPORT:Small Database problem with Supermall]System Administrator a.k.a. The Root of the Problem28 Feb
  • Re: [ 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