Re: how to insert into excel

#1

It sounds like maybe you are using the Data Driven Query
Task? All you need to do is have the SQL Server connection
for the source, the Excel connection file for the
destination. Then you can use a transform data task from SQL
Server connection to the Excel connection. In the transform
data task, just define the sql statement for the data you
want to go to the Excel file. So you end up with just a
select that goes to the Excel file.

-Sue

On Tue, 4 Nov 2003 14:19:57 -0800, "Jen"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Quote:

Hi, I have a dts to create a table in excel connection.
then there is a task to copy the data form db table to the
excel. I specify the db table as SourceObject name,select
statement as the SourceSQLStatement, excel table as
DestinationObjectName, the trouble is how to write the
DestinationSQLStatement, I have "insert into results" , it
complains the syntax error in Insert Into statement.

Thanks

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

Re: how to insert into excel

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

Re: how to insert into excel - 11-05-2003 , 06:56 PM