[dba-SQLServer]Exported spreadsheets not in order

Control Panel/Data Sources or Control Panel/Administrative Tools/Data Sources

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:	Thursday, May 29, 2003 2:33 PM
To:	dba-sqlserver at databaseadvisors.com
Subject:	RE: [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

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com