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: HKEYLOCALMACHINE \ SOFTWARE \ Microsoft \ Jet \ 4.0 \ Engines \ Text "Format" = "TabDelimited" or "Format" = "Delimited(;)"

edit delete
are you sure?
asked Gutha Shiva Karan Reddy

0 answers

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions