Excel as a database frontend or not

Occasional Contributor

i've been mulling around what to use as a db frontend for SQL Server. initially i chose Excel because it's already tabular and have many formatting options. but i read feedbacks not to use Excel that way without any explanation as to why.

 

Why then is Excel not advised as a database frontend?

1 Reply
You have to write lot of codes to manipulate data to database from excel. MS-Access if would be good choice if you are not interested to use C#, Java, Python or other object oriented language. Microsoft Office Access have some built-in object to correspond with MSSQL server database. So, it can be easier.