Excel Data Transfer Add In

10 pts.
Tags:
AS/400
IBM DB2
Printing
I tried transferring data from a physical file (AS400) using the Excel Data Transfer Add In (Client Access) and am getting cells with unreadable syntax. It appears that a space is being populated with a 4040 string etc. Is there a way to get the information transferred without having to modify the data in Excel? Also instead of having 5 columns populate in 1 cell how do I go about populating them in the proper cells? Thanks for your help!!!!

Answer Wiki

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

look for the option to convert CCSID (it may be on the ODBC data source definition, if not in the Excel query)

Discuss This Question: 1  Reply

 
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
  • chenthil
    Hi, could you please check the file whether the Negative sign is for the same column or for next column, i guess the negative sign is for next column, while doing the import wizard in excel please check the columns carefully. suggestion : do the data transfer again and while opening with excel, care full with column breaks please let me know the result.
    480 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