On 23 Mar 2021 22:10:26 -0700, in bit.listserv.ibm-main
(Message-ID:<[email protected]>)
[email protected] (Gadi Ben-Avi) wrote:
>If it's just text, creating a csv file shouldn't be too
difficult, and Excel will be able to read it with no
problems.
>Separate the fields with commas, and if a field has
spaces, surround it with ".
>Format dates and time as something excel will understand
as a date or time.
It's obvious that the easiest way is to create a CSV file.
But it might not be the best way. You have to worry about
data corruption if Excel misinterprets your fields. See,
for instance:
https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates
https://www.youtube.com/watch?v=yb2zkxHDfUE
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
