How to maintain MySQL data

Mysql Data

[jezzer300]

Hi,

I have MYSQL and the MyODBC driver installed.

What's the easy way to maintain the data? I'd like to use excel so I can run reports etc, but it only appears to import data. Can't you somehow connect to MySQL using Excel and edit the data there?

What do you use to maintain the data?

[drbrain]

You're best off using Microsoft Access.

[Timotheos]

PhpMyAdmin [phpmyadmin.net] is a popular one among web based interfaces. It's export feature can do CSV formats for Excel.

If connecting Excel directly is a must then this project at vbmysql [vbmysql.com] looks interesting.

[jezzer300]

Thanks.

I had a look at phpmyadmin, but it only appears to export data, not import. So no improvement over excel import via ODBC.

Now I'm thinking I either work out how access intergrates or write a couple of export / import PHP files so I can cut and paste my data between excel and my database (the latter is what I'm now thinking of to start off with).

If you have any further thoughts, they will be appriciated.

[Timotheos]

I had a look at phpmyadmin, but it only appears to export data, not import

The import function is not in the most obvious of places. In my version under the Structure tab there's a link at the bottom of the page that says "Insert data from a textfile into table". If you save the Excel file as .csv then you can import from there.

Might be worth your time poking around hotscripts [hotscripts.com] for something.

[timster]

If you search the Net for "mysql front end" you'll find lots of options for this, many of them free.

It's possible to use Excel for this instead, but that's neither the easiest way, nor the way to get a lot of functionality which you'll want down the road.