Re: Witango-Talk: SQL 2000 Bug?

[[EMAIL PROTECTED]]

The reason is, that Excel handles CR and Linefeeds in a other way as your Database.   Thats the reason, why .csv works fine, so long as you don't have the ' " ' sign in your datas. Here i have had allready troubles with .csv files and i have use my own seperator for the import into Excel.   regards   Daniel ----- Original Message ----- From: Dan Stein To: Multiple recipients of list witango-talk Sent: Tuesday, May 21, 2002 2:13 PM Subject: Witango-Talk: SQL 2000 Bug? I was able to reproduce this on two machines with a different data set on each machine. SQL 2000 Server Service Pack 1 Windows 2000 Server Service Pack 2 Using the export wizard Export the tables to Excel 92-2001 format When tables are opened in Excel data is not in the correct columns. Not all the data just some. Do same export to .csv and data opened in excel is fine. -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 215-799-0192 610-256-2843 Fax 413-410-9682 FMP,Tango, EDI,SQL 7 [EMAIL PROTECTED] www.dss-db.com ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]                 with unsubscribe witango-talk in the message body