Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#
From Excel I want to convert to Sql Server(database)
 
i have Excel Sheet from that i want to convert to Sql Server (Database)
 
Regards,
Rao
Posted 7-Nov-12 0:01am
Edited 8-Nov-12 22:46pm
v2
Comments
digimanus at 7-Nov-12 6:06am
   
In SqlServer use Tasks->Import data (right mouse click om servername)
mehdi.sabet at 7-Nov-12 8:01am
   
hi you can import you excel table directly in sql server .this way get you a table by
your sheet in excel with same header .you can done this by rightclick on database in sql server and choose import and another step for import excel sheet in sql database;
Tinier at 8-Nov-12 2:23am
   
it seems that excel to sql or sql to excel are permanent topic, actually, you can find a lot of answers in this site, either in forum or in the articles, just search, you will find.
Maciej Los at 9-Nov-12 2:52am
   
And the problem is...

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

First of all, read my comment to your post.
 
Steps to do:
1) design a database[^]
2) import data from Excel[^]
 
More examples:
Import Data from Excel to SQL Server[^]
Import Excel files to SQL Server dynamically[^]
  Permalink  

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



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