open tab-delimited file by oledb connection string 
Author Message
 open tab-delimited file by oledb connection string
Does anybody know how to open TAB delimited file using
OLEDB connection string?
I created ADODB recordset by code:
m_cnADO.ConnectionString=
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\somepath\dbname.mdb;User Id=admin;Password=pass;"
It works fine with comma-delimited files, but for tab-
delimited files I am able to read only first column.

Thank you



Sun, 16 May 2004 21:43:51 GMT
 open tab-delimited file by oledb connection string

On Wed, 28 Nov 2001 05:43:51 -0800, "Gennadiy"

Quote:

>Does anybody know how to open TAB delimited file using
>OLEDB connection string?
>I created ADODB recordset by code:
>m_cnADO.ConnectionString=
>"Provider=Microsoft.Jet.OLEDB.4.0;Data
>Source=c:\somepath\dbname.mdb;User Id=admin;Password=pass;"
>It works fine with comma-delimited files, but for tab-
>delimited files I am able to read only first column.

I believe you must specify "Format=TabDelimited" in the schema.ini
file in the same directory as your tab delimited file. Look up the
article "Schema.ini" in MSDN for information on this file.

However, the connection string you gave appears to be for an Access
(mdb) file, not a comma or tab delimited data file. So I wonder how it
works for comma-delimited.

Chris



Mon, 17 May 2004 00:09:28 GMT
 open tab-delimited file by oledb connection string

Sorry Connection string is:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
C:\FileNAme.txt;Extended Properties='text;FMT=Delimited'"

Quote:
>-----Original Message-----
>On Wed, 28 Nov 2001 05:43:51 -0800, "Gennadiy"

>>Does anybody know how to open TAB delimited file using
>>OLEDB connection string?
>>I created ADODB recordset by code:
>>m_cnADO.ConnectionString=
>>"Provider=Microsoft.Jet.OLEDB.4.0;Data
>>Source=c:\somepath\dbname.mdb;User

Id=admin;Password=pass;"
Quote:
>>It works fine with comma-delimited files, but for tab-
>>delimited files I am able to read only first column.

>I believe you must specify "Format=TabDelimited" in the
schema.ini
>file in the same directory as your tab delimited file.
Look up the
>article "Schema.ini" in MSDN for information on this file.

>However, the connection string you gave appears to be for
an Access
>(mdb) file, not a comma or tab delimited data file. So I
wonder how it
>works for comma-delimited.

>Chris

>.



Mon, 17 May 2004 01:59:52 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. open mdb file and create several tab delimited ascii files

2. Open tab delimited text file

3. I wanna open a Tab-Delimited file...

4. Opening A Tab-Delimited Text File With ADO?

5. Opening A Tab-Delimited Text File With ADO?

6. Changing Tab-delimited file to Comma-delimited

7. tab delimited strings???

8. Help File - Opens on Find tab not Contents tab

9. Converting comma-delimited data to tab-delimited

10. bar-delimit to tab-delimit

11. bcp errors on Tab delimited files

12. DTS Import Tab Delimited Data From Txt File


 
Powered by phpBB® Forum Software