Iseries Access data transfer
I am transferring an Excel file (Tab Delimited) to the AS400. One of the fields is defined as TEXT. Some of the fields have data containg commas. All of the fields that contain commas upload to the 400 enclosed in quotations. Those fields without commas upload without the quotation. I do not want quotation marks. Is there a default that can be changed so as not to upload with quotations?
Thank you
Software/Hardware used:
Software/Hardware used:
ASKED:
January 11, 2006 3:31 PM
UPDATED:
November 24, 2009 7:35 PM
RELATED QUESTIONS
- CPYFRMIMP inserting quotation marks
- upload a pc file to as/400 iseries
- User prompted for AS/400 log on when using Excel Add-in to upload data.
- Using CPYFRMIMPF to transfer data from CSV file to custom table on AS400/
- How to remove comma for individual fields before inserting into comma seperated csv file in RPGLE
Answer Wiki:
If you import the file into access you can then export it to a tab delimited no quotes file and then upload.
To see all answers submitted to the Answer Wiki: View Answer History.
How are you generating the file? By saving from Excel in tab-delimited format? Then, you run iSeries Access file transfer to upload?
What does a line from the file look like when a comma is in the TEXT field? Can you paste a line here?
Tom
If you remove the commas in the fields, you can then use excel to save the file as a .CSV. This will create a file with no quotation marks.