How to batch import files into the database?

I have 20 files that I want to put in separ开发者_运维问答ate tables. All the tables have the same schema though. I was wondering if there is a good way to do this besides using SQL Server Import/Export Wizard (which I believe is targeted towards single file imports).

Any suggestions?

Yes, your best bet and definitely the easiest way would be using BULK INSERT.

See here for more information and implementation: http://msdn.microsoft.com/en-us/library/ms188365.aspx

The bcp utility is probably the easiest way to import those files