8 replies
by jschaiman
by mslizny
I believe that the data is not being cleaned up when it is downloaded from the AS/400. For the simple queries Access manages, but the more complex ones have problems with the quality of the data.
Are your users each downloading from the AS/400 on their own, or is the data downloaded regularly and put in some network location? I am guessing from your information that it is possible that users are downloading the data on the fly and some users are more knowlegeable than others and so the process goes more correctly and smoothly for them. I have worked with many data conversion projects--are you using macros in Excel and Access ro bring the data down from the AS/400? Often users skip some steps and that results in problems. Have you verified the problem on each computer or are you relying on user descriptions of the problems?
by jschaiman
Did you check the Excel files for the consistency of data ? Are all the fields properly filled ? Do you have any error logs after the download ?
But enough questions, the most straight forward thing is to download from the AS/400 to a text file notExcel or any other "sofisticated" softwares as there could be some conflicts between the data formatting. Check the text file first and then you can link that to Access (don't even have to import).
by jschaiman
by tracyp
by jschaiman
by jschaiman
This discussion is closed to new replies.
Trending Desktop posts
Sort by Trending