David Emerson
davide at dalyn.co.nz
Wed May 28 21:16:46 CDT 2003
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