Import Excel to sql server2005

Leave a comment

October 19, 2012 by Er.Hem Raj Thakur

First of all we need to fullfill some of importent work for learn how to import Excel sheet data to SQL Server2005. So here you are some example:-Step 1 – Create the Database and Table
CREATE DATABASE HemGoogali_Test
GO
create table tbl_Employee1
(
Emp_ID int not null primary key,Emp_name varchar(50),Emp_Department varchar(50),EmpDesignation varchar(50),Emp_Address varchar(200));             
Step 2 – Open the Excel worksheet, select data only and copy the data ‘Ctrl +C’
  Copy Paste Step1 Snap
Step 3 – Open SQL Server 2005 Management Studio and navigate to the table
Step3 Snap Shot
Step 4 – Right click on dbo.tbl_Employee1, choose ‘Open Table’ then left click on below area
Step4 Snap Shot
Step 5 – The area below will be highlighted, then right click and choose ‘Paste’ From the Pop-Up Menu.
Step5 Snap Shot
Congratulation ! Your Database has been successfully Imported from Excel Sheet to sql server2005. Enjoy It…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: