Re: ADO + Excel

Article View: pl.comp.lang.delphi.bazy-danych

Article #70526

Back to pl.comp.lang.delphi.bazy-danych Previous Next

#70526

From: wloochacz
Date: Thu, 02 Aug 2007 07:59

20 lines
1621 bytes

> Ach te google, właśnie znalazłem odpowiedź :) Wystarczyło do 
> rozszerzonych parametrów połączenia dodać IMEX=1.
> 
O, tu jest chyba wszystko napisane :)
"Check the following registry settings for the *machine*:

Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/TypeGuessRows
Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/ImportMixedTypes

TypeGuessRows: setting the value to 0 (zero) will force ADO to scan
all column values before choosing the appropriate data type.

ImportMixedTypes: should be set to value 'Text' i.e. import mixed-type
columns as text:

Using IMEX=1 in the connection string (as you have done) ensures the
registry setting is applied."

-- 
wloochacz

Technical Details

Message-ID: <f8s2sg$ou7$1@atlantis.news.tpi.pl>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.nask.pl!news.nask.org.pl!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail

References: <f8q1j5$jrs$1@nemesis.news.tpi.pl> <f8q1oi$3fn$1@atlantis.news.tpi.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.nask.pl!news.nask.org.pl!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail
From: wloochacz <wl@no.spam>
Newsgroups: pl.comp.lang.delphi.bazy-danych
Subject: Re: ADO + Excel
Date: Thu, 02 Aug 2007 09:59:15 +0200
Organization: tp.internet - http://www.tpi.pl/
Lines: 20
Message-ID: <f8s2sg$ou7$1@atlantis.news.tpi.pl>
References: <f8q1j5$jrs$1@nemesis.news.tpi.pl> <f8q1oi$3fn$1@atlantis.news.tpi.pl>
NNTP-Posting-Host: plast-box.pl
Mime-Version: 1.0
X-Trace: atlantis.news.tpi.pl 1186041552 25543 195.205.119.237 (2 Aug 2007 07:59:12 GMT)
X-Complaints-To: usenet@tpi.pl
NNTP-Posting-Date: Thu, 2 Aug 2007 07:59:12 +0000 (UTC)
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
In-Reply-To: <f8q1oi$3fn$1@atlantis.news.tpi.pl>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message