August 29, 2008 10:47pm pdt

1. zorvek 2,107,186
2. rorya 2,046,988
3. saurabh726 1,301,130
4. chris_bot... 776,246
5. byundt 680,182
6. nutsch 546,068
7. patrickab 412,280
8. jeverist 407,238
9. spattewar 316,278
10. matthews... 303,769
11. ahammar 281,891
12. webtubbs 256,684
13. jpaulino 245,997
14. RobSamp... 240,914
15. dj88 210,941
16. irudyk 163,728
17. WJReid 150,302
18. weellio 143,519
19. Psychotec 133,785
20. epaclm 119,855
21. GrahamSkan 107,769
22. jell 100,971
23. Merch_Ops 92,593
24. gtgloner 83,427
25. StellanRo... 80,929

1. zorvek 9,411,677
2. byundt 7,423,271
3. rorya 5,741,719
4. matthews... 2,866,897
5. jeverist 2,817,507
6. patrickab 2,167,843
7. roos01 1,919,714
8. mvidas 1,529,753
9. saurabh726 1,394,709
10. webtubbs 1,353,076
11. fanpages 1,234,722
12. brettdj 1,095,751
13. MalicUK 1,059,396
14. chris_bot... 965,752
15. mgh_mgh... 649,110
16. LoNeRaV... 602,049
17. ahammar 582,024
18. ture 570,551
19. nutsch 546,068
20. spattewar 525,227
21. R_Rajesh 468,975
22. jpaulino 358,896
23. david251 355,614
24. RobSamp... 339,463
25. sebastienm 339,407

06.03.2008 at 08:06PM PDT, ID: 23455478

	[x] Attachment Details

THE BEST WAY TO IMPORT DATA FROM EXCEL

Asked by justin_smith in Microsoft Excel Spreadsheet Software, SQL Server 2005

Tags: Microsoft, SQL Server, 2005, IMPORTING DATA FROM EXCEL, T-SQL

Hi,

I have need to import marketing information into the SQL 2005 from an Excel sheet..
Currently I am using DTS Wizard to import them..

But everytime i do this its a nightmare to get it right...
Even after the automated process i have to manually check if anything has been missed.

For instance if the excel report has field that has actual numbers as well as that look like numbers it mixes them up.. This happens even after i make the entire column to text or general.. So some of the cells are missing after the import..

Further i dont like this idea about the Wizard as well as it is time consuming..

Does any have a better idea to do this..

I have heard about openrowset.. but i dont much about it...
I would prefer a mechanism that gives me much programatic control in accessing and formating the columns while they are imported into SQL server

Thanks Start Free Trial

Keywords: THE BEST WAY TO IMPORT DATA FR…

	Title
1	Excel Import DTS tasks
2	Field date not importing into SQL server…
3	Can I Create an Excel Spreadsheet wit…
4	Format Excel cell as an email address
5	Import Excel to Sql
6	Excel import in ASP.Net

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

THE BEST WAY TO IMPORT DATA FROM EXCEL

Asked by justin_smith in Microsoft Excel Spreadsheet Software, SQL Server 2005

Tags: Microsoft, SQL Server, 2005, IMPORTING DATA FROM EXCEL, T-SQL

About this solution