still excel...

sundogro

ok, i understood, but i am having difficulties exporting the csv file. i have tried a script for auto conversion, jack\'s csv2sql , and it outputs an sql query batch file, about 6 megs. when i try to load it into mysql for execution, i get errors. i am running win95 with winsock2, apache1.3, php4
and mysql.the csv file is \";\" delimited. if someone knows the commands for importing i would be grateful.thanks in advance,andrei( a lousy beginner)

sundogro

the script looks like this
--------------cut test.csv-----------------------
CREATE TABLE test (
ORGANISMEENTREPRISE CHAR(225);
CODE CHAR(225);
THEME CHAR(225);
ACTIVITE CHAR(225);
PRODUITSSERVICES CHAR(225);
ADRESSE CHAR(225);
PAYS CHAR(225);
Ville CHAR(225);
ADRESSEWEB CHAR(225);
TEL CHAR(225);
PARTENAIRESCLIENTS CHAR(225);
REMARQUESTHEMEDESARTICLES CHAR(225);
DATE CHAR(225);
Evnement CHAR(225);
);

INSERT INTO test (ORGANISMEENTREPRISE; CODE; THEME; ACTIVITE; PRODUITSSERVICES; ADRESSE; PAYS; Ville; ADRESSEWEB; TEL; PARTENAIRESCLIENTS; REMARQUESTHEMEDESARTICLES; DATE; Evnement)   VALUES ('@GP'; '41.02.03'; 'EDI/EAI'; 'Logiciels'; 'Logiciels web EDI'; ''; ''; ''; ''; ''; ''; ''; ''; '');
-----------cut test.csv--------------------
this is only one recod, ut the other lines are the same with "insert into test..."
i execute it with "mysql <test.csv" and it says "error 1064 at line 2 you have an error in your sql syntax near '' at line 2"

Anon

Dont use semicolons. Use commas in between the fields on both your create and insert commands.