+ 1

we know that sql is the arrangement of data mostly in a tabular form. then why can't we use excel instead of sql?

27th Dec 2016, 4:56 PM
mathew varghese
mathew varghese - avatar
3 odpowiedzi
+ 2
sql is the language which can manage the databases, excel is a programm which shows the data visually, so there is no problem with using Excel and sql together
27th Dec 2016, 5:02 PM
Kamil
Kamil - avatar
0
Simplifying Excel is math tool, SQL and databases are for storing data and searching through data, so it is not for math. Notice that you cannot do math in SQL. And SQL is 10000% quicker at managing data than excel will ever be. That's why.
27th Dec 2016, 5:03 PM
Mateusz Kifner
Mateusz Kifner - avatar
0
sql is optimized to return your query results faster, but you absolutely can use excel. just set it up as an odbc data source on windows and you are good to go. you could also just use a text file for that matter but again sql will get you speed.
27th Dec 2016, 5:37 PM
david