![csv excel cpyfromimpf cpytostmf](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0OUIEuaUlp8vxTSDPVd90Iszax8fotBKevZ835dYNEzJcIr7fvkYP4jC7q44p6VszCVDb-CrUONFlAROvHq6VTuW6ac-lFRILTkraz8HfxH4DlLeMwybUGb_Bmg9OP2GfrVdxz221kRiM/s200/cl.png)
I am sure we have all been given a Microsoft Excel spreadsheet and told to upload the data from it into IBM i files. The first thing I do with the Excel spreadsheet is to save is as a CSV file. CSV stands for comma-separated values, the data elements, or columns, can be of varying length and are separated with a comma. It could be described as an Excel file without all the special formatting. If you have a Windows PC and you right-click on a CSV file, select "Open with", and then "Notepad" the file will look like this:
First,Second,,"4,444",5.5 First field,Second field,Third field,4.4,"5,555,555" |
In conversations with other IBM i folks I am finding that the "Send file to host" function of Client Access is being shut off on their IBM is as it is rightly regarded as a security risk. What can be used as an alternative?