ADO Delimiters: Space and Tab
-
I've been trying to find a webpage containing the syntax of connection strings, especially for Tab, Space, and multiple delimiters. Right now, I am trying to query a text file that is space delimited where I treat consecutive delimiters as one. The following code snippet is from my connection string in C++ .NET Extended Properties=\"text;HDR=Yes;FMT=Delimited(' ')\"" Do you know what the syntax should be and where I can find a page with a list of the delimiters with syntax? I have examples for csv format, but have not found other examples on google yet.
-
I've been trying to find a webpage containing the syntax of connection strings, especially for Tab, Space, and multiple delimiters. Right now, I am trying to query a text file that is space delimited where I treat consecutive delimiters as one. The following code snippet is from my connection string in C++ .NET Extended Properties=\"text;HDR=Yes;FMT=Delimited(' ')\"" Do you know what the syntax should be and where I can find a page with a list of the delimiters with syntax? I have examples for csv format, but have not found other examples on google yet.
-
Have you tried www.connectionstrings.com/[^]? I have not checked for text file connections, but that site has helped me when I can't remember connection string syntax.
Yes, I already have checked connectionstrings.com. They have examples with Tab, semi-colon, and comma. I have not gotten a space delimiter to work however.