Name: Creating a table , database and importing data from excel
Uploaded: 2012-07-18T09:21:08+00:00
Duration: 7 min 4 s

Creating a table , database and importing data from excel

This video show how to create a database , a table , relationships and a database diagram using sql server management studio. Its also shows how to query data from the table and also how to add or edit data within a table that already been created. The video then moves on to show how you can import data from an excel sheet directly into tables within SQL Server using the import data wizard.

http://msdn.microsoft.com/en-us/libra...
http://technet.microsoft.com/en-us/li...

Video Length: 07:04
Uploaded By: Jayanth Kurup
Published: 7/18/2012
View Count: 92,262

Related Software Products

Excel-to-MSSQL

Published By:
Intelligent Converters

Description:
Excel-to-MSSQL is a program to migrate MS Excel data into MS SQL databases. Each worksheet becomes a table, each row becomes a record and each cell becomes a field. Key features: (1) all versions of MS Excel are supported; (2) converts individual worksheets; (3) merges MS Excel data into an existing MS SQL database; (4) converts Comma Separated Values (CSV) files into MS SQL tables; (5) stores conversion settings into profile; (6) command line support; (7) easy-to-use wizard style interface

MSSQL-to-Excel

Published By:
Intelligent Converters

Description:
MSSQL-to-Excel is a program to convert MS SQL databases into MS Excel spreadsheet. Key features: (1) all MS SQL data types are supported (2) fast conversion engine (20MB MS SQL database - in 1 minute on average P-III system) (3) converts individual tables (4) command line support (5) output spreadsheet is compatible with MS Excel 5.0 and higher (6) easy-to-use wizard style interface