August 29, 2008 07:15pm 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

04.03.2008 at 12:37PM PDT, ID: 23293941

	[x] Attachment Details

How to Bulk insert from Excel 2007 to SQL DB Table

Asked by concordmusicgroup in SQL Server 2005, Microsoft Visual C#.Net

Tags: C#, SQL

Excel file to SQL DB Table

The excel file must be parsed for CheckSums and then transfer columns to a table representation in SQL
The destination has different column names than present within the excel file.

What is the fastest way to import file contents using C#.

Code snippet required for solution acceptance.

Guidance terms: BCP, OLEDB IRowsetFastLoadStart Free Trial

Keywords: How to Bulk insert from Excel 2007 …

	Title
1	Bulk copy in .Net 1.1
2	DataType problem whilst importing Exc…
3	BCP
4	Bcp for exporting PUBS db
5	Best Practice for Bulk Copying Data fro…
6	bcp

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

How to Bulk insert from Excel 2007 to SQL DB Table

Asked by concordmusicgroup in SQL Server 2005, Microsoft Visual C#.Net

Tags: C#, SQL

About this solution