Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 two computers in a client / server architecture. The server runs SQL Server. The client has to provide an interface to insert data to this database.

I know that this can be achieved with Microsoft Access forms but I lack the time to do it. Is there any free software that can do this?

share|improve this question

closed as not a real question by Oliver Salzburg Aug 16 '12 at 12:00

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

How much faster do you want it? You didn't specify the format and nature of the data? – surfasb Sep 7 '11 at 4:44
What do you mean faster? The data will be numbers at a small range. Let's say 001-650. – py_script Sep 7 '11 at 17:25
up vote 2 down vote accepted

It'll take time no matter what software you use.

You should at least be able to install the SQL Server Management Studio (if you're running Microsoft SQL Server) and use that to write a query that'll insert your required data. This program is freely available from microsoft.

UPDATE more information:

Install the Management Studio on your own computer and connect to the database(s) on the SQL server using the Studio.

Then you should be able to run queries and add/update data in the databases as you desire using the Studio.

However, if you already have Access on your computer, it will probably be a better way to do this. The Management Studio was meant as a way to manage the databases and servers, and its query capability is only incidental. Access was meant as a way to interact with the data in databases, and so lacks management function.

UPDATE instructions for inserting data using SQL Management Studio:

First, I will assume you know SQL. If you don't know SQL you should not attempt this. I will not provide actual code you can simply copy and paste into the correct field.

Second, it will be easiest if you already have the data you need to insert entered in a table with the same basic structure as the table on the SQL server you will be updating.

With the Microsoft SQL Server Management Studio installed on your computer, you will need to authenticate to the server/database, then in the Object Explorer, expand Databases.

Select the Database you wish to update, right click and select New Query. There are no wizards here. You will be presented with a blank sheet in which to write your query.

Use an INSERT or UPDATE query to add the records from the table to the database.

NOTE: This can also be done via PowerShell, which may be better if you'll need to do this process regularly. Simply create a staging database where you enter the data you'll want to insert into the database on the server, write a powershell script and save it that imports this data into the database, and run it whenever you need to.

share|improve this answer
I have already done it. :) – py_script Sep 6 '11 at 20:30
Did that allow you to add data? – music2myear Sep 6 '11 at 20:54
Remotely? How? Thats my question :) – py_script Sep 7 '11 at 17:25
I still dont get it dude :s How will the "remote value" be entered to the table? All the stuff you say are correct but basics and already known/done :) – py_script Sep 7 '11 at 19:14
Umm, create table and import? Or a simple insert statement? – surfasb Sep 8 '11 at 1:19

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