-
Adding data to Database or viewing database in msSQL
I am new to ms SQL. I only have the use of the Enterprise Manager.
Creating tables I understand. However I am confused on how to add data to
a table or view the data in a table. Can this be done through Enterprise Manager? If I am adding a large amount of data do I have to use the query window. This seems like a tedious method. In Access yo have a form basically pop up where you can type in the record sets. Any advice would be appreciated! Sincerely,
Bill Bequette
-
Adding data to Database or viewing database in msSQL (reply)
Actually, you can use Access as a kind of 'front-end' to SQL Server, allowing
you to avoid the very tedious process of inputting and viewing records
one at a time. The query manager is more for developing or troublshooting.
If SQL Server has been fully installed, you should have a library (NetLib) which
permits, among other things, various types of connections (IP, Netware, etc), and which can be
connected via ODBC drivers from whatever other software you are using.
You can access this from SQL Server 'Client Configuration Utility. Set the connection to
the appropriate choice, and then set up an ODBC connection to the database.
Email me if yo uwant more details on this.
Bill
------------
Bill Bequette at 6/14/99 5:42:11 PM
I am new to ms SQL. I only have the use of the Enterprise Manager.
Creating tables I understand. However I am confused on how to add data to
a table or view the data in a table. Can this be done through Enterprise Manager? If I am adding a large amount of data do I have to use the query window. This seems like a tedious method. In Access yo have a form basically pop up where you can type in the record sets. Any advice would be appreciated! Sincerely,
Bill Bequette
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|