[Resolved] Software to convert MySQL to Excel???

[gunhoe86]

I searched the forums for this but came up unfruiful....... I've got a client who'd like to be able to convert his MySQL databases to MS Excel format, then he can convert to Access or mail merge it or whatever. I can write a script that generates all the fields seperated by commas and he can copy them all and paste them into the table, but that can take lots of time. I was wondering what the best software for MySQL to Excel format is, if such a thing exists. I know there's software for MySQL to Access, but is there anything for Excel?

Thanks,

~JOSH

[Roger_Ramjet]

Non-problem. If you export the data as a CSV, ie comma seperated as you say you can then opening the file in Excel will automatically import it into rows and columns. Access has the File -> Import function which requires a little more input from the user. On the other hand, in Access if you just copy the contents on an Excel spreadsheet, or open the csv in a text editor and select all-copy, you can open a table as a datasheet and paste it in direct.

You can also select all and copy an html table or page and then paste either direct into Excel.

[gunhoe86]

Excellent, thanks for the help. Works like a charm.

~JOSH