Creating an excel spreadsheet form sql data

[mlynch199]

Is it poosible to write the data from an sql table directly into an excel spreadsheet that already has been creted and contains a macro?

Thanks!
Maurice

 

[DotNetGnat]

i think you can create a DTS package that does this...select the source as the sql server db and the destination as the microsoft excel file...and do the field mappings...

-DNG

 

[AtomicWedgie]

Hello,

maybe search for OPENDATASOURCE in Booms on-line

Regards,

Atomic Wedgie

 

[AtomicWedgie]

Hi,

I mean Books on-Line

Regards,

Atomic Wedgie

 

[TysonLPrice]

Just as an fyi from Excel you can go to Data > Get External Date > Create New Query and run the query from there (There are additional steps required to point at the right data base). This will plug the query output directly into Excel along with column headings.