Comma delimited Table Conversion problem

Hi List,

I'm in E9.1 trying to build the simplest of Table Conversions by saving an Excel spreadsheet to a .csv file, renaming the file to a .txt extension and then resaving it in Unicode format.

Problem occurs when I try to read any individual values. I can see the entire string ok - and if I try to set the format to fixed length (making sure the data matches) I also have no problem whatsoever.

It's only when I do comma delimited do I have the problem.

One of the errors I get in the logs is:
: Can't share buffers, column AA and AA have different types
The first AA represents the IC field that I named and the second represents the OC field defined in the table.
I get one of these errors for every field I've defined except for the character fields that I defined as String size '1'.

Any help or suggestions appreciated.
Ben again,

Ben,

I haven't done this for a long time, but I have never received such an error. If I remember correctly, I used the target table columns to define the incoming csv fields.