[dba-SQLServer]Exported spreadsheets not in order

Uncheck ANSI NULLS and ANSI WARNINGS settings on your DSN.

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 6:11 PM
To:	dba-sqlserver at databaseadvisors.com
Subject:	RE: [dba-SQLServer]Exported spreadsheets not in order

OK, the only place that seems to have any settings is the User DSN 
tab.  But there is nothing to indicate sort orders (or much else).  Part of 
the problem is that I am not sure what I am looking for?

David

At 29/05/2003, you wrote:
>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
>
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com

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