data transfer to excel via client access

5 pts.
Tags:
AS/400
AS/400 Client Access
AS/400 data transfer
Client Access
Data transfer
with client access Version 5.00, I would like to upload a file to excel 2007 by using data transfer command

Software/Hardware used:
as400, client access express for windows version 5.00

Answer Wiki

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

Use the Excel Add-in that’s included with the iSeries Client Access for Windows software.
You get a cool little icon on your Excel tool bar for uploads and downloads.

But I agree the ODBC connection option’s offer you much more features.

<a href=”http://www.code400.com/forum/showthread.php/539-Add-in-for-Excel-to-pull-data-from-AS400″>http://www.code400.com/forum/showthread.php/539-Add-in-for-Excel-to-pull-data-from-AS400
</a>

If Microsoft Excel was installed on your PC after Client Access Express, do the following:

1 Ensure that you installed Data Transfer Excel Add-in support when you installed Client
Access Express. This support is installed during a typical and full installation but may
not have been installed in a custom or 5250 installation.

2 Open Microsoft Excel.

3 Click Add-Ins from the Tools menu.

4 Click the Browse button.

5 Locate the path where Client Access Express was installed.

6 Double-click on the shared folder.

7 Double-click on the cwbtfxla file.

8 Click OK.

Now you can click on the data transfer toolbar icon that appears on your Microsoft
Excel toolbar. You can also run a data transfer request by selecting Transfer
Data From AS/400 from the Data menu.

Discuss This Question: 3  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
    I would like to upload a file to excel 2007 by using data transfer command You can use the data transfer command to create a copy of the file, and then you can open that copy in Excel (if you copied to a compatible format.) You can also use the iSeries Access Data Transfer add-in for Excel. That allows you to request the transfer into Excel while you have Excel open. The add-in needs to be installed before you can use it. What problem are you having? Tom
    125,585 pointsBadges:
    report
  • RonKoontz
    USE ODBC in excel.. Like Tom said.. Works great
    1,780 pointsBadges:
    report
  • Craig Hatmaker
    You may want to consider MS Query since it comes w/Excel (no add-ins) and works w/other databases - not just DB2. If you're not familiar w/MS Query a short demo is here. A screen shot of setting up the Client Access ODBC driver is on the next page of this blog: http://itknowledgeexchange.techtarget.com/beyond-excel/manually-linking-to-data-ms-query/
    1,720 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