Article View: borland.public.cppbuilder.database.ado
Article #3025XLS files via ADO?
From: Dmitry
Date: Wed, 25 Dec 2002 15:18
Date: Wed, 25 Dec 2002 15:18
6 lines
1329 bytes
1329 bytes
I create ADO connection & open XLS file. I can obtain tables with GetTableNames() & Fields names with GetFieldNames(). But with second method I obtain the columns names like F11, F12... which not contains the data. :-( How I can obtain the fields names & number of lines that contains the data (not empty). Thanks.
Technical Details
Message-ID:
<3E09CC60.8010108@iamm.ac.donetsk.ua>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,6acf61b028d9c7d4,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-12-25 08:25:30 PST Message-ID: <3E09CC60.8010108@iamm.ac.donetsk.ua> Date: Wed, 25 Dec 2002 18:18:56 +0300 From: Dmitry <ivanov@iamm.ac.donetsk.ua> User-Agent: Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.ado Subject: XLS files via ADO? Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 213.130.20.14 X-Trace: newsgroups.borland.com 1040833145 213.130.20.14 (25 Dec 2002 08:19:05 -0800) Lines: 7 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail