August 29, 2008 02:48pm pdt

1. chapmandew 2,035,326
2. angelIII 1,369,238
3. aneeshatti... 513,981
4. mark_wills 473,116
5. ee_rlee 313,995
6. brejk 226,005
7. dtodd 209,505
8. momi_sa... 177,049
9. acperkins 173,863
10. rickchild 167,940
11. ptjcb 160,219
12. Thomasian 155,142
13. EugeneZ 143,750
14. BrandonG... 143,655
15. sbagireddi 136,982
16. dportas 125,215
17. ScottPletc... 123,615
18. jgv 115,921
19. appari 114,604
20. PFrog 113,160
21. DanielWilson 106,114
22. chrismc 105,889
23. PedroCGD 104,345
24. tedbilly 103,765
25. bashka_... 98,724

1. angelIII 2,649,429
2. chapmandew 2,035,326
3. aneeshatti... 1,079,086
4. ptjcb 525,611
5. Yveau 517,373
6. mark_wills 473,116
7. dtodd 420,510
8. PFrog 383,188
9. dqmq 368,078
10. appari 350,751
11. imitchie 333,350
12. ee_rlee 313,995
13. acperkins 269,202
14. ScottPletc... 227,282
15. brejk 226,005
16. Lowfatsp... 223,289
17. matthews... 203,352
18. rboyd56 196,590
19. SQL_SE... 190,215
20. EugeneZ 180,459
21. momi_sa... 178,749
22. gbshahaq 177,810
23. tedbilly 172,104
24. DanielWilson 171,904
25. dportas 169,180

06.05.2008 at 06:40AM PDT, ID: 23460098

	[x] Attachment Details

Is there an "Import Wizard" function in SQL 2005 Management Studio?

Asked by colorbok in SQL Server 2005, MS SQL Server

Tags: Microsoft, SQL, 2005

I recently upgraded to SQL 2005. I often have users give me Excel files, which I saved as a Tab-delimited text file and would use the 'Import Wizard' in the SQL 2000 Enterprise Manager to update various fields in a particular table. The files are almost never the same format, fields, tables, etc., so I don't want to have to create a legacy DTS or SSIS for it, since it is only a one-time update.

I'm not finding an import wizard in the SQL 2005 Managment Studio. Any assistance would be greatly appreciated. Thanks!Start Free Trial

Keywords: Is there an "Import Wizard" function i…

	Title
1	SQL 2005 Management Studio DTS …
2	Trying to Query 'Active Directory' in…
3	How do I change the connection on a d…
4	Can't find SSIS
5	Dynamic Output in SSIS
6	Deploy SSIS/DTS package

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Is there an "Import Wizard" function in SQL 2005 Management Studio?

Asked by colorbok in SQL Server 2005, MS SQL Server

Tags: Microsoft, SQL, 2005

About this solution