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

Thread Solved
Reply

Join Date: Jan 2008
Posts: 178
Reputation: sbv is an unknown quantity at this point 
Solved Threads: 8
sbv's Avatar
sbv sbv is offline Offline
Junior Poster

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

 
1
  #1
Mar 20th, 2008
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. ]
Last edited by sbv; Mar 20th, 2008 at 3:25 am.
Accept Challenges and Enjoy Coding... :)
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 4,118
Reputation: peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of 
Solved Threads: 471
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

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

 
1
  #2
Mar 22nd, 2008
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
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)

LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote Quick reply to this message  
Join Date: Jan 2008
Posts: 178
Reputation: sbv is an unknown quantity at this point 
Solved Threads: 8
sbv's Avatar
sbv sbv is offline Offline
Junior Poster

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

 
0
  #3
Mar 24th, 2008
Ya i know. but i was unable to edit that.
Accept Challenges and Enjoy Coding... :)
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Other Threads in the MS SQL Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC