How to import Excel Sheet data into SQL Server 2003 ???? Stpes.

Hi friends.....
As when i am doing this task and found know help ..............
here i am putting steps for importing data from Excel sheet into SQL Server 2003.

How to Import data from excel sheet to SQL Server

Note : - Sheet should be exactly same as Table in which you are importing data. i.e with the contrints and column

sequence.

Step 1) from tool menu select Run a Wizard
Step 2) Click on Data Transformation Services
Step 3) Click on DTS Import Wizard. You will see a wizard for Import/Export . Click on "Next"
Step 4) Choose a Data Source from Drop down list. Here i choose Microsoft Excel 5.0
Stpe 5) Then click on brows button and choose your Excel Sheet to Import and click next
Step 6) Then choose Destination, Server. Choose option Use SQl Server Authentication.
input user name and password. Then select Database
Step 7) Click on Next. choose option copy Tables and views from the source database and click on Next.
Step 8) You will see a list of available sheets from your selected sheet to import. choose sheets to import. (keep in mind the sheets should be formated same as table. you can create a new table also.)
Step 9) Click Destination Field and choose a table in which you want to import data.
step 10) Click on Transform button and select appropriate option. If you havent selected any table in previous step then it will show you a default option to create a new table.
Step 11) Click next and choose timing when to import. and click finish. And the data is in your table.

feel free to ask if any Query.

Best Luck. Enjoy.....

[ if this post is helpful to you then please add reputation to me. thanks in advance. ]

sbv

Junior Poster

178 posts since Jan 2008

Reputation Points: 15

Solved Threads: 8

4 Years Ago

Show Comments

1

I was about give you positive rep, but the comment on bottom change my mind.
[ if this post is helpful to you then please add reputation to me. thanks in advance. ]Scrounging for positive rep is not nice, be ashamed :angry:

peter_budo

Code tags enforcer

Moderator

15,436 posts since Dec 2004

Reputation Points: 2,806

Solved Threads: 902

4 Years Ago

0

Ya i know. but i was unable to edit that.

sbv

Junior Poster

178 posts since Jan 2008