[dba-SQLServer]Exported spreadsheets not in order

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