Ok, I guess I am not sure what exactly you are trying to do here.
You are using the Jet OLE DB IISAM that does Excel?
michka
----- Original Message -----
From: "Mikko Lahti" <MikkoL@onyx.com>
To: "Michael (michka) Kaplan" <michka@trigeminal.com>;
<i18n-prog@acoin.com>; <unicode@unicode.org>
Sent: Thursday, July 27, 2000 3:57 PM
Subject: RE: Excel 2000, ADO and Unicode
> I tried OLE DB as well but results are same. Data type returned is
> adVarChar. Any other ideas?
>
> Later,
>
> Mikko
> Globalization Specialist
> Onyx Software - Bringing e-business and business together
> MikkoL@onyx.com
> www.onyx.com
> 425.519.4172
>
> -----Original Message-----
> From: Michael (michka) Kaplan [mailto:michka@trigeminal.com]
> Sent: Thursday, July 27, 2000 2:46 PM
> To: Mikko Lahti; i18n-prog@acoin.com
> Subject: Re: Excel 2000, ADO and Unicode
>
> Try not using the ODBC driver. use the OLE DB driver, you will be much
> happier with teh Unicode persistence.
>
> michka
>
>
> ----- Original Message -----
> From: "Mikko Lahti" <MikkoL@onyx.com>
> To: <i18n-prog@acoin.com>
> Sent: Thursday, July 27, 2000 2:37 PM
> Subject: Excel 2000, ADO and Unicode
>
>
> > I'm running into a problem when I try to query Unicode data from
Microsoft
> > Excel using the Excel ODBC driver via ADO/VB.
> >
> > My queries work fine w/ ANSI data but not for multilingual (Unicode)
data.
> > I'm just getting ??? back so somebody does not support Unicode.
> >
> > When I looked at
http://msdn.microsoft.com/library/psdk/dasdk/odbc8h4j.htm
> > <http://msdn.microsoft.com/library/psdk/dasdk/odbc8h4j.htm> , if I'm
> reading
> > it correctly, Excel data type TEXT is mapping to SQL VARCHAR and not
> > NVARCHAR, which would be a problem in this case.
> >
> > Is this the case or am I don't something wrong? Is there a workaround
for
> > this (other than not to use Excel)?
> >
> > Later,
> >
> > Mikko
> > Globalization Specialist
> > Onyx Software - Bringing e-business and business together
> > MikkoL@onyx.com
> > www.onyx.com
> > 425.519.4172
> >
> >
> > Here is the VB code:
> >
> > Dim adoConnection As ADODB.Connection
> > Dim adoRecordset As ADODB.Recordset
> > Dim sConnectionString As String
> > Dim sQuery As String
> >
> > 'Instantiate the connection and recordset objects
> > Set adoConnection = New ADODB.Connection
> > Set adoRecordset = New ADODB.Recordset
> >
> > 'Create the connection string
> > sConnectionString = "Driver={Microsoft Excel Driver
> > (*.xls)};DBQ=e:\temp\test.xls;DriverID=790"
> >
> > 'Create the query string
> > sQuery = "select data from ""Sheet1$"" where id = 2"
> >
> > 'Open the connection
> > adoConnection.Open sConnectionString
> > 'Get the recordset
> > adoRecordset.Open sQuery, adoConnection, adOpenStatic,
adLockReadOnly
> >
> >
> >
>
> /* the i18n-prog homepage is at: */
> /* http://www.acoin.com/i18n/i18n-prog.htm */
> /* See the page for removal instructions, etc. */
>
This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:06 EDT