Click here to Skip to main content
13,288,520 members (65,846 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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
Updated 8-Nov-12 23:46pm
digimanus 7-Nov-12 6:06am
In SqlServer use Tasks->Import data (right mouse click om servername)
mehdi.sabet 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 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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.171207.1 | Last Updated 9 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