Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a table in MS SQL server which currently has around 800 records and 20 columns.

I want to manually update and add to the information within this table on a frequent basis.

Would exporting the table to Microsoft Excel (and later and re-importing it back to SQL Server) be the best solution for this, or is there another (free) solution?

Please note that I do know how to export the table data from MS SQL Server to Excel, I am just wondering if this is the neatest way to do this.

share|improve this question
Do you have MS Access available? SSMS? – gbn Nov 27 '11 at 19:02
Yes I have MS Access and SSMS available. – Techboy Nov 27 '11 at 19:33
up vote 2 down vote accepted

Assuming your SQL back-end is an MS SQL server you can use the Microsoft SQL Server Management Studio (Express edition linked) to directly query and edit data (amongst many other things).

Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.

share|improve this answer

More simply, use SQL Server Management Studio (SSMS) or MS Access if you have it available.

If you have SQL Server, you have SSMS...

Although, what is the table there for? Does it have other clients using it?

share|improve this answer
The table is referenced by a web service to get information about ingredients. Although I won't edit the table on the production server - I can edit it in the test server and then publish it to production later. Thanks. – Techboy Nov 27 '11 at 19:36

Many people, my self included, use PHPMyAdmin for MySQL interactions. It may be too slow for what you need though (one entry at a time kind of thing). It's completely free and gives direct access to the database. Even if you don't use if for this I recommend having it available.

share|improve this answer
Thanks, but as mentioned I actually need to update a lot of data at a time. I should have explained my question better though because I can use SSMS, but it's a bit clunky. I think I'm going to stick with exporting it to Excel (I can then manipulate the data in there - sort, highlight missing entries, etc.) and then re-import it back into MS SQL. – Techboy Nov 27 '11 at 22:39

You've already selected an answer, but I was a fan of Evolutility for quick CRUD interfaces. It has support for mass updates and a pleasing UI.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .