I have to upload my Access Data to Oracle Core System.
They need .txt with field length fixed for uploding format.
I fix length by this function in query: -
Trans Amount: Right(String(17," ") & [TETHB],17) - for number
Currency: Right(String(3," ") & [THB],3) - for text
Once I export with...