Click here to Skip to main content
12,758,462 members (29,483 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C#
From Excel Exporting to Sql Server DataBase.
Posted 7-Nov-12 2:20am
Comments
faisal23 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 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 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  
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  

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

    Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.170217.1 | Last Updated 8 Nov 2012
Copyright © CodeProject, 1999-2017
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