BBritain
VIP Member
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,
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,