🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: DBGrid and Excel

#129
From: kubo
Date: Thu, 11 Oct 2007 03:53
39 lines
2356 bytes
Great now i understandet the components how it should be connected
between there.
New problem which i have is where or how could i get the names of the
columns. I try some methods of the calss like ADOTable or DataSource,
but i can't find any.

Atctually how to create and fill the ADOTable fields with the
coresponding column names. I knowe how to do it in Fields editor window
but i need the code which i dont knowe. And then i need to put the names
into DBGrid, is the same i knowe how to do it in BDS Design but i need
it to write inside the code.

please help

Daryl napsal(a):
> Kubo wrote:
>
>> OK until now its ok, but here i have problem with the column names.
>> When i read the data from xls file, the data in firs row are read as
>> the colum name so i lost the firs record. How should i insert the
>> whole data (whit the firs row) into corecrt column witch i chose.
>
> This link may help  http://support.microsoft.com/kb/288343
>
>



Daryl napsal(a):
> Kubo wrote:
> 
>> OK until now its ok, but here i have problem with the column names.
>> When i read the data from xls file, the data in firs row are read as
>> the colum name so i lost the firs record. How should i insert the
>> whole data (whit the firs row) into corecrt column witch i chose.
> 
> This link may help  http://support.microsoft.com/kb/288343
> 
> 
Technical Details
Message-ID: <470d1f9f@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!62.111.101.3.MISMATCH!news.germany.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <4700e523$1@newsgroups.borland.com> <47019f83@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,25aa1d540aa248f4
X-Google-Attributes: gid10698b,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Wed, 10 Oct 2007 20:53:39 -0700
From: kubo <kubisow@gmail.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: DBGrid and Excel
References: <4700e523$1@newsgroups.borland.com> <47019f83@newsgroups.borland.com>
In-Reply-To: <47019f83@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 85.207.135.107
Message-ID: <470d1f9f@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1192042399 85.207.135.107 (10 Oct 2007 11:53:19 -0700)
Lines: 39
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!62.111.101.3.MISMATCH!news.germany.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail