Click here to Skip to main content
15,867,704 members
Please Sign up or sign in to vote.
2.00/5 (1 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)

Regards,
Rao
Posted
Updated 8-Nov-12 22:46pm
v2
Comments
Herman<T>.Instance 7-Nov-12 6:06am    
In SqlServer use Tasks->Import data (right mouse click om servername)
mhd.sbt 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;
[no name] 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

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[^]
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900