Click here to Skip to main content
Rate this: bad
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)
Posted 7-Nov-12 1:01am
Edited 8-Nov-12 23:46pm
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
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[^]

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

  Print Answers RSS
0 DamithSL 485
1 Maciej Los 288
2 OriginalGriff 229
3 Zoltán Zörgő 200
4 BillWoodruff 170
0 OriginalGriff 7,934
1 DamithSL 6,084
2 Sergey Alexandrovich Kryukov 5,449
3 Maciej Los 5,174
4 Kornfeld Eliyahu Peter 4,539

Advertise | Privacy | Mobile
Web03 | 2.8.141223.1 | Last Updated 9 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