<div>
I was able to do the muliple export of tables through odbc. &nbsp;I did this and it is working well.<br />
<br />
Thanks for your help,<br />
Lucy
</div>


I was able to do the muliple export of tables through odbc.  I did this and it is working well.

Thanks for your help,
Lucy

<div>
<div class="content wysiwyg-content">
1. I can use the wizard or DTS<br />
2. I have a directory of &nbsp;text files.<br />
3. I don't want to import one text file at once.<br />
<br />
Is it possible to upload more than one file at once? &nbsp;I am sure it is but the examples I have seen use bcp or &nbsp;dts and we do it one at a time..<br />
<br />
Thank you,<br />
Lucy<br />

</div>
</div>


1. I can use the wizard or DTS
2. I have a directory of  text files.
3. I don't want to import one text file at once.

Is it possible to upload more than one file at once?  I am sure it is but the examples I have seen use bcp or  dts and we do it one at a time..

Thank you,
Lucy


1. Importing multiple text files into sql server ....

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.