Re: Populate dataset with text file
- From: "Dan Rock" <danno492_NOSPAM@xxxxxxxxxxx>
- Date: Mon, 22 Aug 2005 12:08:04 -0400
Thanks Bill, but this will want to send the lines line by line. Using this
method, it is taking about 30 minutes to record 147,000 records.
I am coming to Delphi from MS Access and visual basic and am trying to find
a way to "bulk send" the file into a table, such as MS Access's
DoCmd.TransferText, which takes about 10 seconds. I am CERTAIN that this
functionality would exist in Dephi.
"Bill Todd" <no@xxxxxx> wrote in message
news:4309e019$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> Read a record from the file using the text file I/O routines.
>
> AssignFile
> Reset
> ReadLn
> CloseFile
>
> Assign each record to the DelimitedText property of a TStringList after
> setting the Delimiter and Separator properties.
>
> Each field of the record will now be in an element of the StringList.
>
> --
> Bill Todd (TeamB)
.
- Follow-Ups:
- Re: Populate dataset with text file
- From: Bill Todd
- Re: Populate dataset with text file
- References:
- Populate dataset with text file
- From: Dan Rock
- Re: Populate dataset with text file
- From: Bill Todd
- Populate dataset with text file
- Prev by Date: Re: How to sort data on grid?
- Next by Date: Re: Update - Timeout Expired
- Previous by thread: Re: Populate dataset with text file
- Next by thread: Re: Populate dataset with text file
- Index(es):