Custom delimited text file

if i have multiple custom delimited text file like (comma,vertical bar etc..). i have tried like "Format" = "Delimited(;),(|)" but failed..

Delimited columns
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder;
Extended Properties="text;HDR=Yes;FMT=Delimited";The delimiter can be specified in the registry at the following location:
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Jet \ 4.0 \ Engines \ Text
"Format" = "TabDelimited"
or
"Format" = "Delimited(;)"

0 answers