RE: Import Excel file

[Stephen Landess <steve_landess@xxxxxxxxxxx>]

Gad - 

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. 

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.

If anyone is interested I'll find and post the VBA code.

Gad wrote:
> Many thanks  to all responders
> I did suspect that no native IBM Excel-import method is to be found
> Luckily, our emulation package (BOSaNova) comes with a built-in file transfer utility that supports Excel (import & export) and can be invoked on the user's PC via STRPCCMD
> Not as elegant as I wanted but feasible.