Re: Load from file using asterisk as field delimiter

Hi,

Dan Rock wrote:

> Hi All,
> I have been trying to get a solution for 2 months now, but maybe
> no-one has ever done this??? I have come over from MS Access/VB6
> environment and am still rather new to Delphi. I need to import a
> text file, field delimiter is an asterisk, into an Advantage Database
> table.

that should not be such a great problem. I've done it with another
field delimiter, though

> This process, in MS Access, take about 10 seconds to get the
> data into a temp table. This process, in Delph, takes about 30
> MINUTES. I have indeed used smiImport, same results. I have indeed
> tried appending, and posting one record at a time,....same results.

30 minutes??? How many zillions of records do you have? <g>

Seriously, could we see the code you use to import it? Where does the
delay lay? In the importing or in the posting?

There must be something wrong in it to take such a large time to do it
with smiImport. I recall my procedure importing about 3000 records with
13 fields, some of which needed special conversion, in about 2 to 4
minutes, don't remember exactly. It used ADO+ODBC to access a MySQL
database (goddamn combination...) And i already thought it was veeery
slow :)

> If I am in the wrong newsgroup, can someone point me to the right
> direction?

You say you use Advantage database. Are you using ADO to connect to it?
If yes, you're in the right newsgroup. If not, you could try
b.p.d.database.general

--
Best regards :)

Guillem Vicens
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
in order to contact me remove the -nospam
.