Home > IT Answers > AS/400 > data transfer to excel via client access
Annieguibert
5 pts.
 data transfer to excel via client access
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
ASKED: April 20, 2011  12:53 PM
UPDATED: May 2, 2011  11:00 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  April 26, 2011  6:01 pm  by  Teandy   5,830 pts.
All Answer Wiki Contributors:  Teandy   5,830 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

TomLiotta
 108,360 pts.
 

USE ODBC in excel.. Like Tom said.. Works great

RonKoontz
 1,780 pts.
 

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/

Craig Hatmaker
 1,495 pts.