R
Ruslan Shlain
I am getting data from a text file using the folowing code. It uses the
schema.ini file to define a structure of the datatable in the Dataset. The
default file called schema.ini. I have about 10 or 15 tables i have to
populate. Is there a way to specify an ini file i want to use?
Dim Conn As New
System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & FilePath & ";Extended Properties=""text;HDR=NO;FMT=Delimited""")
Dim Comm As New System.Data.OleDb.OleDbDataAdapter("select * from " &
FileName, Conn)
Dim DS As New DataSet
Try
Comm.AcceptChangesDuringFill = False
Comm.Fill(DS)
End try
schema.ini file to define a structure of the datatable in the Dataset. The
default file called schema.ini. I have about 10 or 15 tables i have to
populate. Is there a way to specify an ini file i want to use?
Dim Conn As New
System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & FilePath & ";Extended Properties=""text;HDR=NO;FMT=Delimited""")
Dim Comm As New System.Data.OleDb.OleDbDataAdapter("select * from " &
FileName, Conn)
Dim DS As New DataSet
Try
Comm.AcceptChangesDuringFill = False
Comm.Fill(DS)
End try