[dba-SQLServer]Exported spreadsheets not in order

David Emerson davide at dalyn.co.nz
Fri May 30 14:16:31 CDT 2003


I appreciate your patience, but I don't see these settings.  I am using 
Windows XP.

David

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



More information about the dba-SQLServer mailing list