Forum Discussion
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...
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.