Re: Import Excel file

[John Yeung <gallium.arsenide@xxxxxxxxx>]

On Mon, Jan 17, 2022 at 11:18 AM Stephen Landess
<steve_landess@xxxxxxxxxxx> wrote:
> IBM and Microsoft have different viewpoints on the layout of CSV files.  I always had problems with ACS file transfer when importing Excel-created CSV files, then I figured out how to use CMPFRMIMPF to import Microsoft-style CSV files.

I actually have never had problems with Excel-created CSVs in Client
Access and iSeries Access. It's hard to imagine that IBM made ACS
*less* adept at uploading than its predecessors.

> However, I wrote an excel macro which will create a CSV file which works properly with ACS file transfer.  In other words, the macro puts quotes double (" ") around the character values and none around the numeric values.

Does it properly handle the cases where Excel would have already
included double-quotes (to escape commas and double-quotes that are
part of the data, for example)?

John Y.