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-04-08 : 09:47:31
|
| Kathleen writes "I have 365 Excel files to import into SQL Server. All are identical having the same fields and total number of rows (300) but different data. I'd like to find an easy way to do this using Bulk Insert or DTS. Is it possible to reference a list of Excel files to import during one of these processes?" |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-04-08 : 10:26:03
|
| You could add a VBScript task and use FSO (FileSystemObject) to loop through the files in a partiular dir, processing each file as you loop.Do you need more details than that, or can you figure it out? |
 |
|
|
|
|
|
Importing Multiple Excel Files