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 - 2003-08-07 : 07:37:44
|
| Michael writes "Hello,I am a newbie to mssql. I have the following situation. I have 100+ text files in a directory. Each text file is about 2GB. They all need to be imported into 1 table. Now I've seen examples about importing a single text file, but I'd like to make something that will automatically loop over the list of files and import them into the table. Currently I'm doing it 1 file at a time...selecting the next file after the import is finished.ThanksMike" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-08-07 : 07:38:51
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=24371That should get you started. |
 |
|
|
|
|
|
import a directory of text files