Importing multiple tables

[Adeboye]

Hi,

I have a report generated daily, each day has an average of 1500000 rows of data.
They have the same number of columns and the same column headings.
Is there a way of importing all the files into a single table in my database.

Any help will be much appreciated.

Adeboye

[gpl]

Take a look at DTS, you can even get it to be scheduled to run every day