BeyondBGCM
asked on
Sql to Excel
I want to fetch 300 columns data to excel, sheet , it is not working , can you suggest me a simple way to do that ,
it is like a table has 300 columns , and i want to transfer data for all the columns to Excel sheet , can you please suggest that .
it is like a table has 300 columns , and i want to transfer data for all the columns to Excel sheet , can you please suggest that .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes, you are correct , but it takes time , more than 30 minutes , to fetch 28000 rows .... and still not diaplaying
ASKER
but above is manual method , and will require lot of time ..... the excel connection with sql is better, but this too is taking lot of time , more than 30 minutes now .....
HI BeyondBGCM,
Yes, It will take time for downloading the number of records. (Number columns + Number of rows).
In your case number of column is 300 and row is around 28000
Yes, It will take time for downloading the number of records. (Number columns + Number of rows).
In your case number of column is 300 and row is around 28000
This is the very simplest method,but in different way.
1- First write the sql query in SQL Server Management Studio to fetch your required data.
2- select "Copy with Headers" in the results by right clicking on results.
3- Copy the data to excel.
Please check the attached screen shot.