I try to link Excel sheet as a linked server to SQL Server 2k.
it works fine, but my problem is, that the Excel sheet contains text data
with czech language characters.
And when I try to view the data from the linked server, the czech characters
are shown incorectly.
How can I set the Linked server to show the czech characters correctly?
thanks for help