I am used to querying a comma-delimited text file using the connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Files\;Extended Properties=Text;HDR=Yes;

where the file is C:\Files\Example.csv

However, I now have a text file that is pipe-delimited ("|") instead of comma-delimited.
Do I need to specify anything more in my connection string or is ADO smart enough to realise the pipes are delimiting the data and the commas are not?