Forum Discussion

rino19ny1's avatar
rino19ny1
Copper Contributor
Jul 28, 2022

Excel as a database frontend or not

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?

excel

1 Reply

  • Harun24HR's avatar
    Harun24HR
    Silver Contributor
    Jul 28, 2022
    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.