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

5 Likes