[HELP]excel on db

[DuaSelipar]

anyone know to connect and edit database with microsoft excell 2010?

[AziQ]

excel used for change/edit anything in cq_action or etc by using column WITHOUT using query .anything more u can ask our mod deadpool .he's more pro in this .

[DuaSelipar]

it is same with editing like using navicat? same query?

[PraDevil[ELITE]]

like aziq said..it just use for editing..but its not a query..its just a method of copy and paste from db to excel and excel to db..its a good editing on excel coz you can understand the db content(what you were editing) more easily..

[King_Arthur]

I see know reason as to why you would want to do this, but a google search shows there are articles on the internet for doing such.

[dungeonmaster]

If you export using navicat your can export in spread sheet and should be able to open it in excel even though editing from a txt files is a lot easier than using excel

[DEADP00L]

Originally Posted by dungeonmaster

If you export using navicat your can export in spread sheet and should be able to open it in excel even though editing from a txt files is a lot easier than using excel

not really its a matter of preference.