Re: Importing data form diferent tables and database types

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

Article #2874

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

#2874

From: Dmitry
Date: Fri, 21 Feb 2003 12:51

17 lines
1660 bytes

Vladimir, I need realize reverse problem: convert data from XLS file 
into any C++ Builder DataSet. Can you help me in this?
Sincerely, Dmitry

Vladimir Afanasyev wrote:
> Table1->First();
> for(int i=1; i <= RC; ++i)
> {
>    for(int j=0; j < Table1->Fields->Count; ++j)
>     {
>         PropertySet Cells("Cells");
>         if(!FieldCanBeString[j])continue;
>         WorkSheet.Exec(Cells << i << j+1 << Table1->Fields->Fields[j]->AsString);
>     }
> Table1->Next();
> }
> Table1->Active=false;

Technical Details

Message-ID: <3E5620B9.6030605@iamm.ac.donetsk.ua>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3e4cf489$1@newsgroups.borland.com> <3e509cbe$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,5718363b56ae1b18
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-02-21 06:10:43 PST
Message-ID: <3E5620B9.6030605@iamm.ac.donetsk.ua>
Date: Fri, 21 Feb 2003 15:51:05 +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: Re: Importing data form diferent tables and database types
References: <3e4cf489$1@newsgroups.borland.com> <3e509cbe$1@newsgroups.borland.com>
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 1045835479 213.130.20.14 (21 Feb 2003 05:51:19 -0800)
Lines: 18
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message