+ 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?
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
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.
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.