OLEDB Access to CSV, Can the Deliminater be changed?

[DeltaWolf7]

Hi,

I am accessing a CSV file via OLEDB and I am using the connection string below.

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Path & "\;Extended Properties='text;HDR=No;FMT=Delimited\'"

My question is can the deliminater be changed from comma to a semi-colon?

 

[cjard]

yes, you have to write a schema.ini file:

http://www.devx.com/tips/Tip/12566
http://msdn.microsoft.com/library/en-us/odbc/htm/odbcjetschema_ini_file.asp?frame=true

 

[DeltaWolf7]

Many, many thanks, your a star.