Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#
From Excel Exporting to Sql Server DataBase.
Posted 7-Nov-12 1:20am
Comments
faisal23 at 7-Nov-12 7:24am
   
If your table is blank directly copy all data from excel and past in edit table data mode but keep remind that columns in table and excel should be same. Other way is to use sql server import export facility. Another way if you are expert in excel then fire query from excel to database.
Al Moje at 7-Nov-12 19:47pm
   
I think you should show field names of your table to import from excel file, by then may some expert could show/give you an example...
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

if you use sql server 2007, you can also see the answer here:
excel to sql server 2007 data transfer[^]
Import Data from excel to SQL server using C# in ASP. NET[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi,
 
See my article if could help....
 
Upload Excel Spreadsheet File to Server
 
Hope this could help...
 
Regards,
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Please find a right answer in a similar question here.
How to convert data from excel to sql server 2005...?[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 254
1 Nirav Prabtani 223
2 Sergey Alexandrovich Kryukov 209
3 _Amy 165
4 Richard MacCutchan 135
0 OriginalGriff 7,799
1 Sergey Alexandrovich Kryukov 6,966
2 Maciej Los 3,994
3 Peter Leow 3,708
4 CHill60 2,742


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 8 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100