Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting and Importing Question?

Status
Not open for further replies.

q4s72534

MIS
Aug 19, 2003
59
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top