mysql alternative? excel?

J

jhansen

New member
Jul 21, 2008
91
0
0
Hey..

Im about to order an outsourcing project.

I want to get data from a database that i can manipulate and change fast. With lots of data. I want to do this in excel.

What should i ask for?

Is .csv the best for this? Or something else? I have no clue about this ;)

Thanks
 


Don't use Excel or CSV. Those are not designed for what you're trying to do. If you don't want to use MySQL (and I can't imagine why not) then go with PostgreSQL or MS Access or MS SQL Server. All are great relational database systems. CSV and Excel are going to become crutches you're stuck walking on if you use them now.
 
danushman said:
Don't use Excel or CSV. Those are not designed for what you're trying to do. If you don't want to use MySQL (and I can't imagine why not) then go with PostgreSQL or MS Access or MS SQL Server. All are great relational database systems. CSV and Excel are going to become crutches you're stuck walking on if you use them now.
Click to expand...

Sqlite (hehe just to confuse the matter)
 
Sorry danushman, but .csv it is...

In one year time when im loosing my hair from the stress, i will get back to you.
 
^^ dito.

There's no reason to cripple yourself in this way.
You can edit mysql using phpmyadmin and it's easy to use.
 
that i can manipulate and change fast.
Click to expand...

The tool for doing this on your desktop, if you're not a DBA or experienced with writing SQL is Excel.

The tool for running a database in a website is MySQL. Getting data out of MySQL into Excel is easy (with for example .csv).

The question is do you need to re-input the stuff you end up with in Excel back into MySQL? If so, you need to work with your programmer on a way to do that.

m
 
google Mysql GUI tools and download it. If you start with your data in Mysql you can dump a table to excel with one mouse drag and a right click. Then you've at least got the opportunity to learn mysql because you'll be in it all the time but you can still put your skirt on and play with bill gates' winkie when you need to.

You'll grow to hate excel pretty damn quickly after you've wasted a lot of time learning how to use it effectively... got any data with more 65k rows? Forget it...
 
You must log in or register to reply here.
Top Bottom