This code was posted as a solution to a prior question. But the last line is incorrect .... any help?
Dim MyConnection As System.Data.Odbc.OdbcConnection
Dim MyDataTable As New DataTable
Dim MyDataAdaptor As System.Data.Odbc.OdbcDataAdapter
Dim strMyConnection, strSavedFolder, strFilename As String
strSavedFolder = "c:\inetpub\ strFilename = "test.csv"
strMyConnection = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" & strSavedFolder & ";"
MyConnection = New Odbc.OdbcConnection(strMyConnection)
MyDataAdaptor = New System.data.Odbc.OdbcDataAdapter("select * from [" + strFilename + "]", MyConnection)
MyDataAdaptor.Fill(MyDataTable)
DataGrid1.DataSource = MyDataTable
DataGrid1.DataBind()
TIA
Jeff
Dim MyConnection As System.Data.Odbc.OdbcConnection
Dim MyDataTable As New DataTable
Dim MyDataAdaptor As System.Data.Odbc.OdbcDataAdapter
Dim strMyConnection, strSavedFolder, strFilename As String
strSavedFolder = "c:\inetpub\ strFilename = "test.csv"
strMyConnection = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" & strSavedFolder & ";"
MyConnection = New Odbc.OdbcConnection(strMyConnection)
MyDataAdaptor = New System.data.Odbc.OdbcDataAdapter("select * from [" + strFilename + "]", MyConnection)
MyDataAdaptor.Fill(MyDataTable)
DataGrid1.DataSource = MyDataTable
DataGrid1.DataBind()
TIA
Jeff