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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-28 : 08:20:53
|
| Virando writes "Hi, I was wondering the easiest way to enter a mass of data into a database from an document such as excel. I have a bunch of country codes, which need country names next to them. Instead of me entering all the countries next to the required field, I thought that there must be a way to import the country names. The excel document i wish to import from also has the country codes.ThanksVirando" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-28 : 08:23:29
|
| DTS can import directly from an Excel sheet. Books Online has details on how to use DTS, but you could just run the Import/Export Wizard and follow the directions and it'll do what you need. |
 |
|
|
|
|
|
Bulk input into database