0

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.

Improve this question
2
  • 1
    Do you have MS Access available? SSMS?
    – gbn
    Nov 27, 2011 at 19:02
  • Yes I have MS Access and SSMS available.
    – Techboy
    Nov 27, 2011 at 19:33

4 Answers 4

Reset to default
2

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.

Improve this answer
1

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?

Improve this answer
1
  • 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, 2011 at 19:36
0

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.

Improve this answer
1
  • 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, 2011 at 22:39
0

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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.