Home > Archive > MS SQL Server DTS > January 2006 > Problem importing £ symbol from Excel to SQL using DTS









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Problem importing £ symbol from Excel to SQL using DTS
Nathan

2006-01-27, 9:23 am

I have created a DTS package (SQL Server 2000) to import data from an
Excel 2002 worekbook into a table.The problem I am experiencing is that
the =A3 sign is being translated as a =FA. Any ideas what might be
causing this.

When I do a Preview on the DTS source query or test the results in the
DTS transformation and then View the results the =A3 sign is being shown
properly.

Setup is
SQL Server 2000. US English language
Windows XP Pro with UK English settings.
Excel 2002 (Sp3

Any help is most appreciated.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com