Ryan Tighe
Dan Gritsko
Mike Beaumont
Jon Herman
Import/Export Database Instruction Manual (SQL Server 2000)


Importing:

-Click the ACTION tab on the top of SQL Server 2000
-Click All-tasks
-Click Import database

You will now be prompted by the Import/Export Wizard 
	
-Click next
-Choose data source (Microsoft Excel 5.0)
-Choose file you wish to import; click next
-Choose data destination ("new") 
-Enter database name; click OK
-Choose "Copy table(s) and view(s) from the source database"; click next
-Select tables to copy (select all); click next
-Choose "Run immediately" for convenience; click next
-Click Finish
-Done




Exporting:

-Right click on database
-Click All-tasks
-Click Export database

You will now be prompted by the Import/Export Wizard 
	
-Click next
-Choose data source (Northwind); click next
-Choose data destination (Microsoft Excel 5.0) 
-Enter File Name; click next
-Choose "Copy table(s) and view(s) from the source database"; click next
-Select tables to copy (select all); click next
-Choose "Run immediately" for convenience; click next
-Click Finish
-Done