Database, open tab-delimited file by oledb connection string

open tab-delimited file by oledb connection string

Author	Message
Gennadi #1 / 3	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

Chris Donova #2 / 3	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

Gennadi #3 / 3	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

Page 1 of 1

[ 3 post ]