•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 375,199 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,979 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 1805 | Replies: 2 | Solved
 |
•
•
Join Date: Jan 2008
Location: India
Posts: 141
Reputation: 
Rep Power: 1
Solved Threads: 5
Junior Poster
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. ]
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 2:25 am.
Accept Challenges and Enjoy Coding... :)
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 1,924
Reputation:
Rep Power: 9
Solved Threads: 221
I was about give you positive rep, but the comment on bottom change my mind.
Scrounging for positive rep is not nice, be ashamed 
•
•
•
•
[ if this post is helpful to you then please add reputation to me. thanks in advance. ]
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
•
•
•
•
access advice ajax architecture asp backup business code combo daniweb data data protection database development doubleclick drive dropdownlist encryption enterprise europe forensic forensics google hacker hard hardware help hitachi internet linux microsoft mmorpg module msdn net news open privacy qmail rhel security server software source sql storage survey terabyte web windows
- Previous Thread: Depth Travesal
- Next Thread: help in performing join
