Trying to read CSV file into VB.NET 2005

[Zim Babwe]

I have some code and I know the Connection string is wrong, but I don't know
the correct syntax. Can someone help please? I want to read a .CSV file
and input the data into a table. Am I on the right track? Any
help/corrctions would be appreciated. This is VS 2005, Windows Application
using VB.NET.
Dim sConnectionString As String = "Driver={Microsoft Text Driver" & _
"(*.txt; *.csv)};Dbq=C:\Stock
Market\;Extensions=asc,csv,tab,txt;"

Dim objConn As New Odbc.OdbcConnection(sConnectionString)
Dim objCmdSelect As New Odbc.OdbcCommand("SELECT * FROM
AMEX_20070302.csv", objConn)

Dim objAdapter1 As New
Odbc.OdbcDataAdapter(objCmdSelect.CommandText, objConn)
Dim objDataset1 As New DataSet()

objAdapter1.Fill(objDataset1, "Table1")
DataGridView1.DataSource = objDataset1.Tables(0).DefaultView
objConn.Close()

[ClayB]

This faq shows some code.

http://www.syncfusion.com/faq/window...earch/942.aspx

===============
Clay Burch
Syncfusion, Inc.

[Zim Babwe]

Thanks, that did the trick.
"ClayB" <cl***@syncfusion.comwrote in message
news:11**********************@d57g2000hsg.googlegr oups.com...

This faq shows some code.

http://www.syncfusion.com/faq/window...earch/942.aspx

===============
Clay Burch
Syncfusion, Inc.

[PFC Sadr]

dude don't listen to these kids
use BULK INSERT in order to import CSV into a table
ADO.net is bloatware; sorry


On Mar 20, 9:43 am, "Zim Babwe" <[e-mail]>
wrote:

I have some code and I know the Connection string is wrong, but I don't know
the correct syntax. Can someone help please? I want to read a .CSV file
and input the data into a table. Am I on the right track? Any
help/corrctions would be appreciated. This is VS 2005, Windows Application
using VB.NET.

Dim sConnectionString As String = "Driver={Microsoft Text Driver" & _
"(*.txt; *.csv)};Dbq=C:\Stock
Market\;Extensions=asc,csv,tab,txt;"

Dim objConn As New Odbc.OdbcConnection(sConnectionString)
Dim objCmdSelect As New Odbc.OdbcCommand("SELECT * FROM
AMEX_20070302.csv", objConn)

Dim objAdapter1 As New
Odbc.OdbcDataAdapter(objCmdSelect.CommandText, objConn)
Dim objDataset1 As New DataSet()

objAdapter1.Fill(objDataset1, "Table1")
DataGridView1.DataSource = objDataset1.Tables(0).DefaultView
objConn.Close()