anyone know to connect and edit database with microsoft excell 2010?
[HELP]excel on db
12/30/2010 10:17
DuaSelipar#1
12/30/2010 10:32
AziQ#2
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 .
12/30/2010 11:32
DuaSelipar#3
it is same with editing like using navicat? same query?
12/30/2010 13:34
PraDevil[ELITE]#4
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..
12/30/2010 15:09
King_Arthur#5
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.
12/30/2010 23:39
dungeonmaster#6
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
12/31/2010 06:32
DEADP00L#7
Quote:
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.