I'm exporting an access table description into a txt file and then into a ETL(ascential) tool. In the access table the field description in one cell looks this:
Field Description
value:
one
two
three
After I export the table into a txt file, the Field decsription looks like this:
value:[][]one[]two[]three
when I re-import the table into an ETL table definition, then one cell turns to 4 cells shown below
Field 1 Field 2 Field Description
jack Lisa value:
one
two
three
What should I do? How do I get rid of the boxes"[]". They seem to be carriage returns.
Thanks
Field Description
value:
one
two
three
After I export the table into a txt file, the Field decsription looks like this:
value:[][]one[]two[]three
when I re-import the table into an ETL table definition, then one cell turns to 4 cells shown below
Field 1 Field 2 Field Description
jack Lisa value:
one
two
three
What should I do? How do I get rid of the boxes"[]". They seem to be carriage returns.
Thanks