Generate Data Table - Column Separator not working right

[MaurerDa]

For anyone wondering: The activity does not work properly and has not received any fixes.

Problem with Generate Data Table Activity

Hi, From my experience, the Generate Data Table is glitchy. You could try Chr(9) instead of vbTab. You could also try using a different delimitter in your text. It still might have problems though, cause I always have problems with it. As a workaround, you can use Write Text file with .XLS (tab-delimitted) or .CSV (comma-delimitted) extension. Then, Read CSV or Read Range to convert data to data table. Regards. C