Text File connection via ADO

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

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Student Wed, 10 Jan 2001 15:34

#5912

Author: Student
Date: Wed, 10 Jan 2001 15:34

8 lines
1164 bytes

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

Re: Text File connection via ADO

#5915

Author: 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
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads