Entering Data in to Tables

[terpster]

Was wondering if there was a feature in MS Sql that was similar to the datasheet view in Access?

thanks

 

[AWithers]

If you have the correct permissions you can edit/add records using enterprise manager. Right click on the relevant table and select 'return all rows' This gives you a similar view to access in which you can add/edit data

Andy

 

[tlbroadbent]

Enterprise Manager is a DBA and Developer tool. It should NOT be given to users in general. You can use MS Access as a front end tool for SQL Server databases. Either attach SQL Server tables in an MDB or in SQL 2000 you can create an ADP (Project) file. Data can then be entered using a data sheet view if appropriate permissions are granted in SQL Server. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[SQLSister]

Another alternative if you have someone you want to create a lot of records but who you don't want to give SQL permissions to is to have the user create a spreadsheet and then import it using DTS. This is not good for day to day entry, but if you are trying to originally populate a table with information that previously has not been stored electronically, it is a good workaround. Just setup the spreadsheet with the column names in the first row and tell the data entry person not to skip any rows. Also tell him/her which columns must have data any explain any constraints the data must have. We do this with our receptionist all the time because none of the developers have the time to type in data to populate tables and she doesn't need access to sql server (especialy not for our customers' databases that we host).