Re: Text File connection via ADO

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

Article #5915

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

#5915

From: Eko Subagio
Date: Thu, 11 Jan 2001 17:57

29 lines
1698 bytes

Use Connection String as Microsoft OLE DB Provider
for ODBC Drivers, then Set ODBC Driver for Microsoft
Driver Text Files(txt,csv) ( Make sure you already add
Microsoft Driver Text Files in User DSN via ODBC Administrator ). In ODBC
Administrator set the directory
where your text file exist. So you dont need set in ADOConnection String.

Then do what you want....

Regards
Eko Subagio
www.delphi-jedi.org
www.geocities.com/ekosbg




"Student" <kevin.wise@mtifwb.com> wrote in message
news:93hvev$bjg10@bornews.inprise.com...
> Does anyone know how to do this in a delphi ConnectionString?
>
> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\pathtotextfile;Extended
> Properties="text;HDR=YES;FMT=DELIMITED"
>
> Then you should be able to do the following:
>
> select * from textfile.txt
>
>

Technical Details

Message-ID: <93j76t$rf82@bornews.inprise.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out.usenetserver.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!not-for-mail

References: <93hvev$bjg10@bornews.inprise.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,cde1990c5fbeb7d
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-01-10 19:00:04 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out.usenetserver.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!not-for-mail
From: "Eko Subagio" <ekosbg@cbn.net.id>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Text File connection via ADO
Date: Thu, 11 Jan 2001 09:57:59 -0800
Organization: Another Netscape Collabra Server User
Lines: 31
Message-ID: <93j76t$rf82@bornews.inprise.com>
References: <93hvev$bjg10@bornews.inprise.com>
NNTP-Posting-Host: 202.155.14.161
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700

Reply to Parent Message