This may sound silly, but is it possible to use a TXT file as your data source file? Or is there any way it can be used?
The reason I asked this question is because I was informed by overseas colleague that an exported job (schedule job) from SAP via FTP, can only be formated as TXT file. I find it hard to believe this.
When i view the TXT file from excel, you have to format it to "text to column" and spend some time dividing it by the column.
Thanks in advance.