Having SQL results populated in Excel?

[kairick]

I'm not sure if I should post this here or in the other area, but I was wondering if there's a script reference or something where I can have form results entered into my database and have them automatically entered into an Excel sheet as well? Seems like that would be a default operation somewhere.

I'm using Drupal CMS but to my knowledge there's no module for that there, so would there be an SQL query I can enter in PHPmyAdmin that would achieve the same effect?

I know accessing the print view for my tables creates a readable view for my client, but they want an editable table they don't have to understand PHPmyAdmin to work.

Thanks!

[djr33]

That's very complex and probably difficult to do while maintaining much control. You can use PHPMyAdmin to export an excel version of a database, or you can use a CSV to transfer between the two. Using an automated process would be harder.
Honestly, PHPMyAdmin is not hard-- it's made to eliminate the need for command line interaction.
Not sure exactly what to suggest, but unless you want to code your own admin interface (very possible using PHP, but time consuming), it'll probably be easier to teach them PHPMyAdmin (if that's an option) rather than dealing with Excel. And if they can use Excel, there's no real reason they can't use PHPMyAdmin... it's not that much more complex (even if it looks like it is at first).

[kairick]

That's what I figured.

How would I get it to export an Excel version of the data? Or does Excel read .sql files? that would be awesome.

[djr33]

PHPMyAdmin has "excel" as one of the export options. I've never tried it, but I've seen it there. It may only be available in the "table" export menu, not the export menu for the whole database (that would make sense, considering what excel could display).

[kairick]

Wow what a "duh" moment for me. I think I've been up too long.

I'm just going to tell them at the end of registrations for their events, to just export the table for a complete list. They want everything to be automatic, but it's kind of one of those have your cake and eat it too things and it's not in the budget or timeline to create an automated interface.

As always, thanks for your help.