Excel Imported Data

15 pts.
Tags:
AS/400 import/export
Microsoft Excel
Import data from an AS400 using the query function in XL. Hangs. Connection is ok, finds the tables but when it tries to retrieve records an write to XL work sheet it just hangs. Can anyone help. I believe it is a job on the AS400, but which one?
ASKED: July 29, 2008  2:19 AM
UPDATED: July 30, 2008  5:20 PM

Answer Wiki

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

Hi,

How many records are in the file you’re trying to retrieve, excel has a limit of around 65535.

Regards,

Martin Gilbert.

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
  • MECA
    Hello Martin I have tried files with 100 records and 100000 records. Makes no difference.
    15 pointsBadges:
    report
  • GAC
    Hi MECA, Have you tried using the iSeries access download program? If you can download the data from there then it might be an XL problem, maybe a component is corrupted and you need to reinstall it. But if you cannot from the iSeries Access download program then it might be a data problem (those programs use SQL and there might be a data conversion problem). Gerardo.
    300 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