I tried transferring data from a physical file (AS400) using the Excel Data Transfer Add In (Client Access) and am getting cells with unreadable syntax. It appears that a space is being populated with a 4040 string etc. Is there a way to get the information transferred without having to modify the data in Excel? Also instead of having 5 columns populate in 1 cell how do I go about populating them in the proper cells?
Thanks for your help!!!!