I know I have touched on this before, is it possible to
import records using DTS from the sequel server that will
bring the table into excel and when we run this each night
it will replace the old spreadsheet with the new one. I
cannot seem to make it replace a spreadsheet and this is
what I want it to do.

Thanks again.

Two (maybe three) options the way I see it:

1. Output as a CSV file named .xls - this will open Excel automatically, put
everything into columns, and easily overwrite any existing files. No
formatting and such, but it works for basic data needs.

2. Issue a DELETE statement against the Excel connection to delete all rows.
Then insert them back in. Alternatively, issue DROP and CREATE TABLE
commands against the Excel connection. This will delete and re-create the
table.

3. Look into SQL Reporting Services - you can set up a schedule to pull this
data (if it can be queried easily) and one of the formats is Excel. Also
allows you to e-mail it if desired.

-=Pete

"PaM" <pcoleman (AT) police (DOT) nashville.org> wrote:

Also you could:
1) Create and call a .bat file
2) Use strong data migration tool instead (Data Junction).