🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #4963

Re: How to access excel?

#4963
From: Lee Gan
Date: Thu, 06 Sep 2001 14:47
15 lines
1423 bytes
You can access Excel files with many ways. Here are two of them.

1. via COM interface by calling the COM APIs of Excel. You need to have
Excel installed through.
2. via ADO. See http://www.able-consulting.com/ADO_Conn.htm for the
connection string.

I have tried both methods and they all work. Good luck. Lee Gan

"liuch" <liuch@jinglun.com.cn> wrote in message news:3b8d8e01_1@dnews...
> when to use TTable Commponent to access excel file,
> After Dataname fill  director,           Tablename cann't  select excel
> file.
>
>
Technical Details
Message-ID: <3b978c85_2@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!newsgate.cistron.nl!news.tele.dk!small.news.tele.dk!194.213.69.151!news.algonet.se!algonet!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews
References: <3b8d8e01_1@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,c6c73e7011bb24a5
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-09-06 07:55:31 PST
From: "Lee Gan" <leegan@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3b8d8e01_1@dnews>
Subject: Re: How to access excel?
Date: Thu, 6 Sep 2001 08:47:28 -0600
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 207.34.102.197
Message-ID: <3b978c85_2@dnews>
X-Trace: dnews 999787653 207.34.102.197 (6 Sep 2001 07:47:33 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!newsgate.cistron.nl!news.tele.dk!small.news.tele.dk!194.213.69.151!news.algonet.se!algonet!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews