[dba-SQLServer]Apostrophes in exported spreadsheets

Thanks.

At 29/05/2003, you wrote:
>David,
>
>The apostrophe is an Excel, not an Access, specification for a text
>field.  Thus Access doesn't need it, but Excel does, so Access puts it
>in when you export text strings to Excel.  A string delimited by quotes
>also indicates a text field to Excel.
>
>Charles Wortz
>Software Development Division
>Texas Education Agency
>1701 N. Congress Ave
>Austin, TX 78701-1494
>512-463-9493
>CWortz at tea.state.tx.us
>
>
>
>-----Original Message-----
>From: David Emerson [mailto:davide at dalyn.co.nz]
>Sent: Thursday 2003 May 29 14:25
>To: dba-sqlserver at databaseadvisors.com
>Subject: RE: [dba-SQLServer]Apostrophes in exported spreadsheets
>
>
>The thing is that it didn't happen when I had A97 linked to an A97
>BE.  Text cells just had the text in them without the apostrophes.
>
>Another unusual thing is that some text fields have apostrophes at the
>beginning and end of the text, other text fields only have an apostrophe
>at
>the beginning!
>
>David
>
>At 29/05/2003, you wrote:
> >David,
> >
> >That apostrophe tells Excel that what follows in the cell is to be
> >treated as text, not numbers.  If you want the cell values to be
> >treated as numbers, then you need to change the exporting field
> >datatypes from varchar to numeric datatypes.
> >
> >Charles Wortz
> >-----Original Message-----
> >From: David Emerson [mailto:davide at dalyn.co.nz]
> >Sent: Wednesday 2003 May 28 21:17
> >To: dba-SQLServer at databaseadvisors.com
> >Subject: [dba-SQLServer]Apostrophes in exported spreadsheets
> >
> >When I use the following line in an ADP linked to SQL2K, any varchar
> >fields have an apostrophe put at the front of the data -
> >
> >strTableName = "dbo.ttmpLoadAllocateExp"
> >
> >DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7,
> >strTableName, "C:\Sheet.xls
> >
> >Does any one know why, and how can it be avoided?
> >
> >
> >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