Question Moving CSV to Datatable

[JimmyFo]

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:

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

 

[cjard]

I think you need a space between Data and Source