Click here to Skip to main content
11,496,146 members (302 online)
The site is currently in read-only mode for maintenance. Posting of new items will be available again shortly.
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 1:01am
Edited 8-Nov-12 23: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

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)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 10,401
1 OriginalGriff 8,910
2 Sascha Lefèvre 3,899
3 Maciej Los 3,422
4 Richard Deeming 2,600


Advertise | Privacy | Mobile
Web02 | 2.8.150520.1 | Last Updated 9 Nov 2012
Copyright © CodeProject, 1999-2015
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