Iseries Access data transfer

0 pts.
Tags:
AS/400
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
ASKED: January 11, 2006  3:31 PM
UPDATED: November 24, 2009  7:35 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you import the file into access you can then export it to a tab delimited no quotes file and then upload.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • Teandy
    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.
    5,860 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following