Until recently, I would pull all of my tables off of the AS/400 (IBM System i) through the ODBC external data interface in Access. Now when I try to pull anything over, I get the ODBC call failed error. It was suggested to me that the error was caused by a change to our SQL server. Unfortunately our IT people have no idea how to fix the problem and I am not set up to change anything in SQL; and even if I was, I wouldn't know where to begin.
That being said, I am still able to import the data into Excel. We have an Add-In set up to Transfer data in and out of System i. What I need is the VBA code to automate the transfer process in Excel. Once I can get that piece figured out I can pull it into Access. I would really appreciate help with this issue.
That being said, I am still able to import the data into Excel. We have an Add-In set up to Transfer data in and out of System i. What I need is the VBA code to automate the transfer process in Excel. Once I can get that piece figured out I can pull it into Access. I would really appreciate help with this issue.