GetTableNames in Excel with ADOConnection

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

Article #2687

Back to borland.public.cppbuilder.database.ado Previous Next

#2687

From: Michael removetheXXX
Date: Mon, 07 Apr 2003 19:02

16 lines
1535 bytes

I am successfully connecting to an Excel spreadsheet by setting:
ADOConnection1->ConnectionString.
"Data Source=C:\TestDB\Extract.xls;Extended Properties=Excel 8.0"

When I try to get a list of TableNames using:
ADOConnection1->GetTableNames(ComboBox1->Items, true);
the ComboBox is empty.

If I connect to an Access database using this method I can get a list of
tables.

Finally, if I connect to the Excel sheet while designing the app. I can see
the available tables in a drop down ADOTable1->TableName

Any suggestions appreciated
Michael F.

Technical Details

Message-ID: <3e91cb5c$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-08!supernews.com!news-out.visi.com!petbe.visi.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,7677464668601a66,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-04-07 12:06:49 PST
Reply-To: "Michael removetheXXX" <XXXyodlaf1@yahoo.com>
From: "Michael removetheXXX" <XXXyodlaf1@yahoo.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: GetTableNames in Excel with ADOConnection
Date: Mon, 7 Apr 2003 15:02:59 -0400
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 204.92.255.22
Message-ID: <3e91cb5c$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1049742172 204.92.255.22 (7 Apr 2003 12:02:52 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-08!supernews.com!news-out.visi.com!petbe.visi.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail