ODBC Text Driver Issue for Tab delimited File

I am trying to do a ODBC Connection to a Tab delimited file. However it is
not parsing the tabs. Any advice?
Thanks
Here is my connection string:
Private ConnectionString As String = "Driver={Microsoft Text Driver (*.txt;
*.csv)};DRIVERID=27;Fil=Text;Format=TABDELIMITED;" & _
"COLNAMEHEADER=TRUE;DefaultDir=" & _
Application.StartupPath
And my calls to query the file:
Dim Adapter As New OdbcDataAdapter("SELECT * FROM Test.csv", Con)
When you use the Text Driver, the format is determined by
the schema.ini file. The format statement goes in the
schema.ini file. That's how I remember it anyway.
The following link has more information on the drive and a
link to information on the schema.ini file - watch out for
line wrap on the link:
http://msdn.microsoft.com/library/de..._details. asp
-Sue
On Tue, 1 Feb 2005 06:55:04 -0800, "Neil"
<Neil@.discussions.microsoft.com> wrote:

>I am trying to do a ODBC Connection to a Tab delimited file. However it is
>not parsing the tabs. Any advice?
>Thanks
>Here is my connection string:
> Private ConnectionString As String = "Driver={Microsoft Text Driver (*.txt;
>*.csv)};DRIVERID=27;Fil=Text;Format=TABDELIMITED; " & _
> "COLNAMEHEADER=TRUE;DefaultDir=" & _
> Application.StartupPath
>And my calls to query the file:
> Dim Adapter As New OdbcDataAdapter("SELECT * FROM Test.csv", Con)
>
>
|||Thanks Sue. That was the solution.
Neil
"Sue Hoegemeier" wrote:

> When you use the Text Driver, the format is determined by
> the schema.ini file. The format statement goes in the
> schema.ini file. That's how I remember it anyway.
> The following link has more information on the drive and a
> link to information on the schema.ini file - watch out for
> line wrap on the link:
> http://msdn.microsoft.com/library/de..._details. asp
> -Sue
> On Tue, 1 Feb 2005 06:55:04 -0800, "Neil"
> <Neil@.discussions.microsoft.com> wrote:
>
>

ODBC Text Driver Issue for Tab delimited File

I am trying to do a ODBC Connection to a Tab delimited file. However it is
not parsing the tabs. Any advice?
Thanks
Here is my connection string:
Private ConnectionString As String = "Driver={Microsoft Text Driver (*.
txt;
*. csv)};DRIVERID=27;Fil=Text;Format=TABDEL
IMITED;" & _
"COLNAMEHEADER=TRUE;DefaultDir=" & _
Application.StartupPath
And my calls to query the file:
Dim Adapter As New OdbcDataAdapter("SELECT * FROM Test.csv", Con)When you use the Text Driver, the format is determined by
the schema.ini file. The format statement goes in the
schema.ini file. That's how I remember it anyway.
The following link has more information on the drive and a
link to information on the schema.ini file - watch out for
line wrap on the link:
http://msdn.microsoft.com/library/d...ail
s.asp
-Sue
On Tue, 1 Feb 2005 06:55:04 -0800, "Neil"
<Neil@.discussions.microsoft.com> wrote:

>I am trying to do a ODBC Connection to a Tab delimited file. However it is
>not parsing the tabs. Any advice?
>Thanks
>Here is my connection string:
> Private ConnectionString As String = "Driver={Microsoft Text Driver (
*.txt;
>*. csv)};DRIVERID=27;Fil=Text;Format=TABDEL
IMITED;" & _
> "COLNAMEHEADER=TRUE;DefaultDir=" & _
> Application.StartupPath
>And my calls to query the file:
> Dim Adapter As New OdbcDataAdapter("SELECT * FROM Test.csv", Con)
>
>|||Thanks Sue. That was the solution.
Neil
"Sue Hoegemeier" wrote:

> When you use the Text Driver, the format is determined by
> the schema.ini file. The format statement goes in the
> schema.ini file. That's how I remember it anyway.
> The following link has more information on the drive and a
> link to information on the schema.ini file - watch out for
> line wrap on the link:
> http://msdn.microsoft.com/library/d...a
ils.asp
> -Sue
> On Tue, 1 Feb 2005 06:55:04 -0800, "Neil"
> <Neil@.discussions.microsoft.com> wrote:
>
>