Re: Importing data form diferent tables and database types

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

Article #2897

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

#2897

From: Vladimir Afanasyev
Date: Thu, 27 Feb 2003 08:56

28 lines
2307 bytes

Dmitry,

Dmitry <ivanov@iamm.ac.donetsk.ua> wrote:
>Vladimir, big thanks to your answer. I think it can help me. But
>what you means about this: when I create DataSet runtime & load data
>from CSV file I need additional conversion from CSV because CSV is
>not DB format & it don't support by Borland DB engine.

It will be strange to work with CSV file using BDE:
1) You do call TDataSet method
2) TDataSet method calls BDE (or another function that calls 
BDE)
3) BDE USING file system (BDE does not work directly with 
physical HDD drive - it use file system Win32 API: CreateFile, 
ReadFile, WriteFile, CloseHandle)opens tables, index files, 
verifies structure of tables etc, etc, etc., load data...

It is very slowly to use BDE for working with linear files.
In this case are possible to use Win32 API (CreateFile,...) or 
file mapping, or streaming input. It is more quickly.

But if you know ranges of data in the Excel file (for example: 
C1:F1, C10:F10). You can use the same way that I used for 
DB -> Excel converting but vice versa and no need to create 
table in run-time.

Vladimir.

Technical Details

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

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer2.atl.newshosting.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

References:

<3e4cf489$1@newsgroups.borland.com> <3e509cbe$1@newsgroups.borland.com> <3E5620B9.6030605@iamm.ac.donetsk.ua> <3e5a1ee5$1@newsgroups.borland.com> <3E5C4E09.5070009@iamm.ac.donetsk.ua>

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-27 01:04:07 PST
From: "Vladimir Afanasyev" <avv@systema.kiev.ua>
Sender: "Vladimir Afanasyev" <avv@systema.kiev.ua>
Reply-To: "Vladimir Afanasyev" <avv@systema.kiev.ua>
Subject: Re: Importing data form diferent tables and database types
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 62.244.14.114 62.244.14.114    
X-Forwarded-For: 192.168.0.147
References: <3e4cf489$1@newsgroups.borland.com> <3e509cbe$1@newsgroups.borland.com> <3E5620B9.6030605@iamm.ac.donetsk.ua> <3e5a1ee5$1@newsgroups.borland.com> <3E5C4E09.5070009@iamm.ac.donetsk.ua>
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3e5dd2a0$1@newsgroups.borland.com>
Date: 27 Feb 2003 00:56:00 -0800
X-Trace: newsgroups.borland.com 1046336160 207.105.83.65 (27 Feb 2003 00:56:00 -0800)
Lines: 28
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer2.atl.newshosting.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

Reply to Parent Message