from excel to sqlServer

I am having An excel file containing name and phone numberHow can I insert this data to a database table (sqlserver2005)?Hope some one can help mesujith

Do you have SQL Server Management Studio installed? If you do, you can import your Excel spreedsheet to SQL Server as a table.

1.Right click on your database name, follow the Tasks>>Import Data...;

2. Choose excel as you data source; browser to where your excel file is;

3. follow along the instruction on following windows and click NEXTs until you finish.

If you have problem to finsh, please post back here.

|||

Hi,

Yes you can import export wizard as mentioned in the previous post or you can take a look at this thread:http://forums.asp.net/thread/1442470.aspx

AndHow to import data from Excel to SQL Server demonstrates how to import data from Microsoft Excel worksheets into Microsoft SQL Server databases by using a variety of methods

Hope it helps.