Mixing AS400 data and excel spread sheet data

[Guest.Visitor]

I have an excel spreadsheet with infomation entered through excel and mixed in is data reteived from the as400 through client access. The problem is when I try to sort this information, the data from the as400 does not mix into the entered data. I formatted the cells so that they are all the same (text) but they still do not mix. It stays at the end of my sheet.

[Guest.Visitor]

Amanda, I don't have a whole lot to go on here, but this should have nothing to do with Client Access. My first guess is that all of the data is not being selected when you choose to do the sort. What type of data is in the column that you are trying to sort? Did you format the data type in that column before you loaded it with data, or after you loaded it. (If after, that's too late.) Bill

[Guest.Visitor]

Amanda: Assuming that you are using Client Access Express (which is what I have and use when doing file downloads)I feel, that when you download the data from AS400 to Excel, one of the things that you (or the person responsible for download) may not be doing is to check the box for "Convert CCSID 65535" in "Conversions" tab under "Properties" for the file being downloaded. Check this box before you download files to Excel and you should be fine. Hope this helps.

[Guest.Visitor]

I use VBA-ADO to do most anything you want in Excel with DB2. I give users buttons to pull data in from the AS400 based on parms. They also have the means to write, update, and delete from DB2 files via SQL in my VBA. ADO stands for Active Data Objects (Active X) and really performs well. I also have drop down boxes for users to pull info from just like lookups on the AS400. A simple file xfer to the PC and a subsequent import into Excel is wasting your time. Check the downloaded code section for articles that will show you how. Tx

[Guest.Visitor]

First of all we only have v3m0 cics as400. Regular Client access not client access express. I format all the columns before I sort and yes I select expand sort before I actually do the sort. It will not mix the transferred data with the entered data on the excel sheet.

[Guest.Visitor]

Amanda, I guess the only way we could get to the bottom of this problem would be to work with the actual spreadsheet data. If you wish, you can attach the spreadsheet to your reply. OR, if you like, you can send it to me at brobins3d@yahoo.com and we can work on this off-line. Bill