converting access to mysql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • wassimdaccache
    New Member
    • Apr 2007
    • 222

    #1

    converting access to mysql

    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
    Recognized Expert Expert
    • Nov 2006
    • 5062

    #2
    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.

    Comment

    Working...