Re: Load from file using asterisk as field delimiter

Sorry Guillem,
I currently only have the smiImport component. (got p****ed the other night
and deleted the import code).
There are by the way a total of 247,938 records that I am importing

"Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx> wrote in message
news:4315ac9d$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> 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


.

Relevant Pages

  • Re: News Group problem
    ... Newsgroup settings can be Exported and Imported, but not the newsgroups themselves unless you backed up the registry. ... MS-MVP Outlook Express ... > Outlook Express Files/Folders to OE6, however, when importing the MSN ... > Post replies back to News Group ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: TransferSpreadSheet import excel to access problem (undesired reordering)
    ... another newsgroup, so if one of the experts answered your same question in ... I've got a problem importing a worksheet Excel into a temporary table ... This code imported perfectly all the records from the excel file but ...
    (microsoft.public.access.externaldata)
  • Re: transferSpreadSheet problem importing excel to access
    ... another newsgroup, so if one of the experts answered your same question ... I've got a problem importing a worksheet Excel into a temporary table in ... This code imported perfectly all the records from the excel file but since ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using MS Project with Team Foundation Server
    ... You might get a better response from the server newsgroup. ... I have tried to change between the Default task types in Project. ... correct Finish date when I refresh after importing the work item. ...
    (microsoft.public.project)
  • Re: SceCli error 1202, 0x57
    ... are too large for posting here. ... rights. ... >> New error today after importing a security template. ...
    (microsoft.public.windows.group_policy)