January 13, 2004 at 6:53 am
Hi, I have SQL 2000 and excel Xp. Is it possible to export a resultset from SQL to an already preformatted excel spreadsheet????
January 13, 2004 at 7:03 am
Don't know about a resultset but you can certainly copy a SQL table to Excel using DTS - add two connections then use a transform data task. If you can insert the results into a table then I guess you can just DTS that across.
January 13, 2004 at 7:08 am
cheers for that .... that should do it !!
January 13, 2004 at 7:25 am
Would this help http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=16694
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply