Hello
I have save an excel file as a CSV file. Out of 11 columns, 8 are occupied with data. The CSV file would reflect:
Column1Data,Column2Data,Column3Data,Column4Data,Column5Data,Column6Data,Column7Data,Column8Data,,,
The last three commas denotes the last three columns that have no data. However, the last three commas are shown only till the 16th line. It happens on other excel file converted to CSV format.
Can I create a VBA programme or other language to read the file and inputthe three commas?
Pls advise. Thank you.