Re: Excel

#1

Personally I use DROP TABLE and then recreate the table in Excel when i want
to do this. Others, like Darren, use Templates.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"kb7149" <member42243 (AT) dbforums (DOT) com> wrote

Quote:

Help! I am dumping data from a SQL view to an Excel spreadsheet every
night via DTS. The problem is that I need to clear the spreadsheet out
before each data dump. I thought that I would create an Active X
script that would open the Excel workbook and delete the various
worksheets at the start of the workflow. Is this the best way of
accomplishing this? If it is, where do I find the Excel objects or
does anyone have an code examples?

Thanks,

kim

--
Posted via http://dbforums.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Excel

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Excel - 10-14-2003 , 01:24 AM