dbTalk Databases Forums  

dts query and export to excel

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


Discuss dts query and export to excel in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
xandi
 
Posts: n/a

Default dts query and export to excel - 04-10-2005 , 03:36 AM






Hi,
has anyone an eyample for vb wo to do an query and afterwards export this
query to exel?
reg bxandi




Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: dts query and export to excel - 04-10-2005 , 05:04 AM






Gruess Gott bxandi.

Was hat diese frage mit DTS zu tun?
Benuetzen Sie DTS oder?

Wenn Sie DTS benuetzt dann ist es ganz einfach zu tun. Folgen sie dieses beispiel aber statt eine "Text File Source", wahlen Sie
ein "Excel Source". Mann kann eine Suchanfrage in die "Data Pump task" tippen.

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

tut mir leid ist dieses beispiel nicht auf Deutsch gescrieben.



Hi bxandi

What has this to do with DTS
Are you using DTS
If you are using DTS then follow this example, instead of a "Text File Source" choose an "Excel Source". You can type a query in
the "Data Pump task"

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

I'm sorry this example is not written in German.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"xandi" <bxandi (AT) gmx (DOT) at> wrote

Quote:
Hi,
has anyone an eyample for vb wo to do an query and afterwards export this query to exel?
reg bxandi





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.