When trying to upload German characters from an Excel sheet to a database
table using DTS package the following happens:

Characters can be read in the Excel sheet. After uploading, the characters
cannot be read from the database table. The characters are replaced by a
square.

Does anyone know what I should do to overcome this problem?

Thanks in advance!
--


Regards of type best,

BoB

Hi
What is COLLATION of the database? What is datatype of the column
(NVARCHAR(n))?

If you run the below , what do you see?

SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\MyExcel.xls";
User ID=Admin;Password=;Extended properties=Excel 8.0')...Book1$


"BoB Teijema" <bob_dot_teijema_at_gmail_dot_com> wrote in message
news:4BEAC8DC-016B-4636-A0FF-3BF0737CE3B1@microsoft.com...
> When trying to upload German characters from an Excel sheet to a database
> table using DTS package the following happens:
>
> Characters can be read in the Excel sheet. After uploading, the characters
> cannot be read from the database table. The characters are replaced by a
> square.
>
> Does anyone know what I should do to overcome this problem?
>
> Thanks in advance!
> --
>
>
> Regards of type best,
>
> BoB
>

Thanks for your reaction.

according to our dba the database is SQL7. What I could find out about
collation:
Character set is 1252/ISO Character set (default)
Dictionary order, case insensitive
Unicode collation, Locale Identifier: General Unicode

I don't have sufficient rights to run the query you mentioned. However,
using the preview button in the DTS Package does show the characters
correctly!

Thanks for your !


Regards of type best,

BoB


"Uri Dimant" wrote:

> Hi
> What is COLLATION of the database? What is datatype of the column
> (NVARCHAR(n))?
>
> If you run the below , what do you see?
>
> SELECT *
> FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
> 'Data Source="c:\MyExcel.xls";
> User ID=Admin;Password=;Extended properties=Excel 8.0')...Book1$
>
>
> "BoB Teijema" <bob_dot_teijema_at_gmail_dot_com> wrote in message
> news:4BEAC8DC-016B-4636-A0FF-3BF0737CE3B1@microsoft.com...
> > When trying to upload German characters from an Excel sheet to a database
> > table using DTS package the following happens:
> >
> > Characters can be read in the Excel sheet. After uploading, the characters
> > cannot be read from the database table. The characters are replaced by a
> > square.
> >
> > Does anyone know what I should do to overcome this problem?
> >
> > Thanks in advance!
> > --
> >
> >
> > Regards of type best,
> >
> > BoB
> >
>
>
>