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 £ sign is being translated as a ú. 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 £ 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.