exporting mysql to access

[Anon]

hi. I'm trying to export mysql to access, so i can get a pretty printout of all the tables and fields. Is there an easier way (i.e. without converting) or does anyone know of a mysql db converter?

[[deleted]]

The 'converting' way:
mysqldump lets you specify the format of the data, so you can output CSV data, with ; delimited fields etc.

The non-converting way:
it should be possible to use odbc to connect directly to mysql, but you'll have to do a search for more info.