April 1, 2008 at 10:50 am
Hi!
I've searched for a solution to this problem all over and found numreous solutions, but I can't seem to get this one to work!
What I want to do is to export a view to file (.xls) via DTS with dynamic filename.
* The view contains 8 columns if that is of importance
* The filename should be "Lev_YearWeek.xls"
Normally I use the DTS Import/Export Wizard to do this, but if you suggest any other way I'm open...
If you need any more info, please shout...
Thanks in advance
/Martin
April 4, 2008 at 3:34 am
You can use sql "OPENROWSET" that is what im using and i can easily generate an excel file (report) with dynamic name on it example lester_yyyymmdd.xls try reading this good article
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/
"-=Still Learning=-"
Lester Policarpio
April 4, 2008 at 6:41 am
I think I'm in love with you...
Thank's a lot!!! :satisfied:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply