Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: C# ASP.NET infragistics
Dear Team ,
Please help to fast export data for database to Multiple excel sheet.
Forcelly describe to Not cell wise export Bulk Export with Fast Export ..

Rohit Singh
Posted 13-Feb-12 2:54am
Edited 13-Feb-12 2:57am
Rajesh Anuhya at 13-Feb-12 7:57am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

If you want to export a database manually, to a Execl file by using SQL2005 export and Import Wizard this is the way.
0. Create a Execl file in 2003 format.
1. Go to your Database
2. Right click on the DB-> Tasks -> Export Data ..
3. Now you can see the export Wizard.
4. Click Next,check if the database is correct, If not change it. -> Next
5. Select the Destination as Microsoft Excel.-> Give the file path where you created the Execl file. -> Next.
6. Select 1st option -> Next
7. If you want to export all tables select all, or select as you want. -> Next
8. -> Finish.
9. Open the Execl file, the default first 3 pages may be blank. After that you can see your tables in each page.
Think it is the same in SQL2008.
*** if you want to add a password to Execl file
1. Go to Save as.
2. There is a option called Tools near Save button, click it -> General Options
3. Dive the Password as you want.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Advertise | Privacy | Mobile
Web04 | 2.8.150327.1 | Last Updated 13 Feb 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100