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 |
|
nishi57
Starting Member
20 Posts |
 Posted - 2007-11-06 : 12:57:53
|
| I wanted to see what would a way for me to import data from an excel document into an existing database. I have a database in which I want to clear out the current entries and import data from the excel document into that database. What is the best way of doing this??Any help or comment will be appreciated.Nishi |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-11-06 : 13:25:55
|
| There are multiple ways to do this..Try the DTS Import/Export wizard via Enterprise MGr -> Tools -> Data Transofmration Services -> Import Data to start with..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
nishi57
Starting Member
20 Posts |
Posted - 2007-11-06 : 13:43:54
|
| Got it thanks.Nishi |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Import data from excel to another database?