[wassimdaccache]

Hello

I am trying converting a query in MSACCESS 2007 into *.csv File to upload them on the web server MYSQL database using PHPMYADMIN

Actually I am a little bit confused because there are many types of *.csv file (common delimited, Macintosh, Dos )

Is *.csv file type is the best file format for MYSQL to be imported ?

[Atli]

Hi.

CSV files can easily be imported into MySQL using the LOAD DATA INFILE syntax.

The command is created to work with files created by the SELECT INTO OUTFILE syntax, but any file that matches the format of such a file can be used.

My suggestion would be to create a sample database and export it using the SELECT INTO OUTFILE syntax. Then you could see exactly how your data needs to be formatted to work with the LOAD DATA INFILE command.