hi
I have two tables which I export to excel with DTS with option drop and
recreate table. Problem is that excel file is after export around 3 Mb and
if it is open, saved and closed it drops to 1,6 Mb. Becouse I need to
automate this is it possible to do something to initialy get 1,6 Mb after
export, and why is it double size?

Thanx

Dubravko

Hi Dubravko:

Before I export the MS Excel file I usually overwrite the default file with
a template file (The one SQL DTS creates for you when you create the
Transformation. I store this in a template directory, and my first step is
to overwrite this file with the template, then do my export.

hope this helps,
Anthony

--
Anthony J Biondo Jr. - MCP
Senior Web Developer
Keystone Mercy Health Plan - Philadelphia, PA
www.keystonemercy.com

"Dubravko Modrusan" <dubravko (AT) recro (DOT) hr> wrote