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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-12 : 08:29:17
|
| Saeer writes "Hi guys,When I transfer a table from SQL Server into and excel sheet, the resultant excel sheet displays Apostrophe (') in every column before the data.Is there a way that I can import data without having apostrophies being pre-attached to each column? I even set the "text identifier" to "none", but it still does not work.Thanks for your help.Sincerely,Saeer J." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-12-16 : 22:39:03
|
| Try exporting the SQL Server data to tab-delimted or comma-separated format, then open the file in Excel. Excel will read it natively, especially if you give the file an .XLS extension (no wizard will pop up) bcp and DTS can be used to output to either format (and others too...see Books Online for more info) |
 |
|
|
|
|
|
Issue transferring data via DTS to Excel