Excel Dates - is there an auto-magic way of loading Excel files
Hi,
having some problems with Excel and its dates format on Talend 4 using java jobs.
how should i do to import Excel files with java jobs.
thaks
Nicolas
Hello guys,
Regarding importing date from excel files, i just consulted an experience user which gave really useful hints as
follows:
Just add single inverted comma ' to make it text while it's in date format.
It then will have the date converted to date string instead of 4XXXX numbers.
And then u can import the excel / csv in whatever dd-mm-yy format it is.
Clement
