Question Moving CSV to Datatable

JimmyFo

Member
Joined
Aug 15, 2005
Messages
13
Programming Experience
1-3
Hi, I am trying to open a comma-delimited file and put it into a database. I already searched this forum and did what was suggested. I still get an error that reads "Could not find installable ISAM"

Here is my connection string exactly as it exists during runtime:

Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\temp\;Extended Properties="Text;HDR=No;FMT=Delimited"

I define it here:

VB.NET:
Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\temp\;Extended Properties=""Text;HDR=No;FMT=Delimited""")

and it fails as soon as I do cn.Open()

Any ideas?

Thanks,
James
 

Latest posts

Back
Top