Export Data from an Access Database to MYSQL

[Jak82]

Hi There,

Whereabouts would I change the date format from the access database from yyyymmdd ?

I am trying to convert this table from access into mysql, and when I ouput to a csv file the date is in access.

Many Thanks

Chris

 

[Dennisk]

use the format() function to change the order of dd, mm, yy and seperators