I try to transfer an excel file to AS400 vis client access.
In the excel file I have the numeric data in a character column.
I parameter the access to conver the numeric to character and it work.
My problem is when the numeric in excel has more than 6 digits like (6108312457) I receive in the as400 charater field a data like (6.10831E+009).
in the lower part you have a example of the excel file and the as400 result file.
Need you advice to receive the data like it was in the excel file (6108312457)
thanks
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
You can also load directly from excel
1. Create using the excel plugin
in excel use "Tools/Addins" menu
if you do not see iSeries Access data Transfer click browse and go to
c:\program files\IBM\Client Access\Shared and select cbwtfxla
you will get two other tools
select the rage to transfer and then select transfer to icon, base the new file on the excel workbook and follow the prompts.
You can configure each cell as charater, date, numeric field etc.
dave
Thinks for your solutions, but not fit with my case:
- First, the transfer will to run in batch by the user.
- Second, is true that when I format the column as Text and refresh all cells the problem is resolved, but I project to give the platform to the users, who will use copy and paste to fill the file.
So the user can override the format.
Still need other solution please.
Thanks.
We had a similar problem in a recent web application we designed where users uploaded XLS documents that we had to open. We solved it using Excel automation to open up the document that we received, format the cells to text, and save the changed document.
Possible solutions:
HI Everyone,
I have both the character and the numeric in this column,
the solution of adding the leading or trailing blank, is not good for me because, like I said before, is the user who will fill the excel file (by copy paste) and run the batch job from as400.
I work actually on the Gary Patterson solution. I will add the auto_close macro which will transfer the colunm to text.
you will have the my feedback
thnks for all,
Business Accounts
Answer for Membership
by: Gary_The_IT_ProPosted on 2009-02-12 at 07:56:54ID: 23623204
Try formatting the Excel column as text, and eliminate the numeric-to-text conversion from your file transfer.
- Gary Patterson