Re: How to read in fields/records from csv file

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

Article #1573

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

#1573

From: Viatcheslav V. Vassiliev
Date: Thu, 20 May 2004 09:41

39 lines
2239 bytes

Most DBMS have methods to import data from text files, including csv. This
should be in DBMS documentation. If you will write what DBMS you are using,
may be somebody will help.

If you want to use API, TStringList is the best solution. Then just split
string on ',' char.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Vinci Zhang" <zhangzhihao_sz3c@hotmail.com> �������/�������� � ��������
���������: news:40ac612f@newsgroups.borland.com...
> Dear All
>      I have a telephone record file(telrecord.csv,csv file), including
call
> records:
>     No, CalledNo, CallTime
>     1, 125676886, 00:00:13
>     2, 786896865, 00:05:09
>     3, 689787755, 00:02:01
>     I want to know how I can read in the records/fields from the csv by
> programming and transfer text file to database records:
>     1    125676886    00:00:13
>     2    786896865    00:05:09
>     3    689787755    00:02:01
>     How can I do it by API function or other ways, thanks!
>
> Sincerely
>
> Vinci Zhang
>
>
>
>

Technical Details

Message-ID: <40ac7d4a@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!t-online.de!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <40ac612f@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,b302e1879dadbda6
X-Google-Attributes: gid10698b,public
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado,borland.public.cppbuilder.database.dbexpress
References: <40ac612f@newsgroups.borland.com>
Subject: Re: How to read in fields/records from csv file
Date: Thu, 20 May 2004 13:41:32 +0400
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 213.234.218.42
Message-ID: <40ac7d4a@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1085046090 213.234.218.42 (20 May 2004 02:41:30 -0700)
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!t-online.de!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message