hi,i am using visual basic 2008 express edition and i am trying to write a mysql command like this:

myCommand.CommandText = "SELECT 'id','Nr_cupon','Nume','Prenume','zi','luna','an','Localitate','Strada','Numar','Bloc','Scara','Ap','JudetSector','CodPostal','Sex','Profesie','NrCopii','Venit','Email','TelefonFix','TelefonMobil','IdRevista1','Revista1','IdRevista2','Revista2','IdRevista3','Revista3','AcceptInfo','CodFarmacista','zi_complet','luna_complet','an_complet','Data_adaugarii','err_tot','err_pren','err_dn','err_mail','Trimis','operator','Gr_Sang','Nr_Temp','frecventa','subiect1','subiect2','subiect3','subiect4','subiect5','subiect6','recomandari','CNP','verificat','Data_Export','Ora_Export','zi1','luna1','an1','zi2','luna2','an2','zi3','luna3','an3','zi4','luna4','an4','Comunic_Posta','Comunic_Mobil','Comunic_Mail' UNION SELECT * INTO OUTFILE 'c:\export" & juve & ".csv' FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '" ' LINES TERMINATED BY '\r\n' FROM colectare where trimis=0;"

the problem is with OPTIONALLY ENCLOSED BY ' " ' , it gives me a mysql error there.

i also try ' \" ' but still no effect.