Export data from SQL to excel spreadsheet

[cathy68]

Hi Guru:
I tried to use DTS import/export wizard transferring data from SQL to excel spreadsheet. I only transfer one table, there are 30 columns in the table.After finish transferring, I open the spreadsheet, there is only first column of the table I can view, rest of columns don't show up, how strange???? I tried using either"Copy tables(s) and views from the source database" or "Use a query to specify the data to transfer", None of them are successful.

Does anyone know what is wrong?

Cathy

 

[Wholsea]

I, personally, have never had much success with this, I have however, found that exporting to a CSV works wonders.

VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ

 

[dbomrrsm]

Totally agree - I avoid excel like the plague