Article View: borland.public.cppbuilder.database.ado
Article #129Re: DBGrid and Excel
From: kubo
Date: Thu, 11 Oct 2007 03:53
Date: Thu, 11 Oct 2007 03:53
39 lines
2356 bytes
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-mailReferences:
<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