I am trying to use DTS to create a table from a query, but I would like to run this DTS weekly to overwrite the existing table. I can run the query through the DTS and create an Excel sheet without a problem, but when I change the DTS to insert into a table, the table is empty. I do not know if I should look to something besides DTS to do this. To clarify, this is what I am looking to accomplish. I currently use intermediate .xls files and use a custom sort to get the results I need. The issue is that I have a different .xls file for every year, given an .xls file can only hold 65,000 results or so. I wanted to create a new table to run a simple query as opposed to running a query with multiple joins everytime. The new table only needs to hold records from the last 36 months, so I would like to repopulate on a monthly basis. Any thoughts?