Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
praveenk
Starting Member
1 Post |
 Posted - 2009-12-02 : 11:28:31
|
| Hai everybody I have a table i need to import this in to Excel sheetby a Queiry Please help mepraveen |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-12-02 : 11:45:26
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926 |
 |
|
|
Jarid.Lawson
Starting Member
7 Posts |
Posted - 2009-12-02 : 11:45:31
|
| I usually use Tasks>Export Data (right-click the database name), and export it to a flat file in .csv format (.txt is default so be careful). From there I use Excel to view and resave the file into .xls or xlsx format. Keep an eye on this though because Excel has a bad habbit of dropping leading zeros. You may need to reformat a column into Custom and note a set number of zeros on the righthand side of the format screen.There is also an option to export directly into Excel, but I have not had as much luck with this option. Granted I have not given it too much of a chance, but when going directly into Excel (or even using the option described above) you need to keep an eye on the total number of records. Make sure they don't exceed the number of rows Excel normally has.Jarid Lawson"A little knowledge is dangerous. So is a lot." - Einstein |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-12-03 : 03:24:55
|
quote:
Originally posted by Jarid.Lawson
I usually use Tasks>Export Data (right-click the database name), and export it to a flat file in .csv format (.txt is default so be careful). From there I use Excel to view and resave the file into .xls or xlsx format. Keep an eye on this though because Excel has a bad habbit of dropping leading zeros. You may need to reformat a column into Custom and note a set number of zeros on the righthand side of the format screen.There is also an option to export directly into Excel, but I have not had as much luck with this option. Granted I have not given it too much of a chance, but when going directly into Excel (or even using the option described above) you need to keep an eye on the total number of records. Make sure they don't exceed the number of rows Excel normally has.Jarid Lawson"A little knowledge is dangerous. So is a lot." - Einstein
You may need to try the link postedMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
import table into excel