Hi Everybody,

I need to export a table of many columns to text from SQL Server, and
I'm checking that exported file in Excel. The problem is the
customer's required delimiter. They insist we use hash-star-hash (#*#)
as the delimiters in the final text file, and even after recording an
import in Excel and modifying the following "OtherChar" parameter as
shown below, the import still does not work correctly.

Workbooks.OpenText Filename:= "my_delimited_file.txt",
Origin:=-535, StartRow:=1, DataType:=xlDelimited,
TextQualifier:=xlTextQualifierNone, _
ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=
False, _
Space:=False, Other:=True,
OtherChar:="#*#",
FieldInfo:=Array(...

So apparently it's not as simple as replacing the OtherChar argument.

Looking for suggestions! Thanks,
-Eric B.