SELECT INTO *.XLS

[tennessee]

I need to know if there is a way to select * from sometable into (excel spreadsheet) without using dts wizard.

Thanks for any help!

 

[RajD]

Hi,
You can do either of two ways:

1) bcp out the data into a text file and then open that text file into MS-Excel

2) Open a MS-Excel workbook and import data from SQL server, using Data--> Get External Data... from the menu.

RD

 

[robsuttonjr]

FoxPro does this very easily using ODBC to interface data on SQL server. Here is sample syntax in FOXPRO:

SELECT * FROM xyz INTO CURSOR Cxyz
COPY TO xyz.xls XL5

Nice thing is you can then create an executable which can be run again.