[dba-SQLServer]Exported spreadsheets not in order

Thanks.  Where do I find these settings?


At 29/05/2003, you wrote:
>Check into differences of MDAC level and DSN settings between 
>machines.  Bottom line, - those are the contributing factors.
>
>Robert Djabarov
>Senior SQL Server DBA
>USAA IT/DBMS
>? (210) 913-3148 - phone
>? (210) 753-3148 - pager
>
>
>  -----Original Message-----
>From:   David Emerson [mailto:davide at dalyn.co.nz]
>Sent:   Wednesday, May 28, 2003 9:43 PM
>To:     dba-SQLServer at databaseadvisors.com
>Subject:        [dba-SQLServer]Exported spreadsheets not in order
>
>I have another problem with exporting to spreadsheets.  I have three
>spreadsheets that are created for three companies within a database.  The
>data is first put into a temporary table by a sproc which sorts the records
>in the right order by a varchar field.  In two cases when the table is then
>exported to excel they records are still in the same order.  In one case
>though the first chunk of records appear at the end of the
>spreadsheet.  They are still in the correct order but it is as if they were
>deleted from the top and pasted to the bottom.
>
>It only happens for 1 of the three companies, it consistently happens, and
>to make matters worse, it works fine on my machine, but has the problem on
>another.
>
>Has anyone experienced this before or is it just a plan by psychiatrists to
>drum up more business?
>
>
>Regards
>
>David Emerson
>DALYN Software Ltd
>25b Cunliffe St, Johnsonville
>Wellington, New Zealand
>Ph/Fax (877) 456-1205