Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amodi
Yak Posting Veteran
83 Posts |
 Posted - 2008-09-24 : 03:09:56
|
Hello Friends, How to Import Data into Sql database from an Excel file using a wizard Where there is a WiLL there is a WaY |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 03:14:20
|
| You've Export Import wizard in Enterprise Manager if sql 2000 or in SQL management studio if SQL 2005. lauch wizard, select Excel file as source and sql table as destination. Make sure excel file columns are correctly mapped to table column. Set enable identity insert property if your table has an identity column and run it. The excel data will be transferred to sql table. |
 |
|
|
amodi
Yak Posting Veteran
83 Posts |
Posted - 2008-09-24 : 03:28:28
|
| Thanks Visakh, Its nice to see an indian here.Where there is a WiLL there is a WaY |
|
|
|
|
|
|
Import Data to Sql server using Wizard