export from Access so MYsql can read it

[Montagna, Dan]

Hi everyone,
 
I'm using an Access database and trying to use a macro to export to a text
file for mysql.  It's no problem to export to a text file, but it's in a
format that mysql won't recognize.  I know it just needs to be formatted on
export a little but the macro options aren't available for the extra
formatting.  Any help on how to export to the proper .txt format would be
great.
 
Thanks
 
Dan