Export to Excel with delimitators

[BadStorm]

Hi,
i need to export a txt file that have as delimitaort "|" and i want to
export that file in a new excel file from a vba function.

Any ideas?
Thanks

 

[Alex Dybenko]

Hi,
you create a new query, concatenate required fields like:
[Field1] & "|" & [Field2] & "|" & [Field3] & "|" & [Field4 ]

and then export it using transferspreadsheet method

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com