File Transfer to iSeries from Excel 2007

I am using the iSeries Client Access for V5R4, and trying to transfer an Excel 2007 (.xslx) file. There is no corresponding file type to choose from (only goes up to Excel 2003 (BIFF8). Is there any other way to do this using Client Access

Badkarma40 pointsBadges:

Preventing users using Operations Navigator

We have many users with Ops Navigator installed as part of their iSeries Access client software. Is there a way (preferably on the iSeries) to prevent these installations of Navigator working? Ops Nav should never have been installed (historical thing, long story...) and we have now built a custom...

djac900 pointsBadges:

Internal License Error in Windows XP

Good afternoon, we are using IBM I-Series Access for Windows on Windows XP system. Approximately every 4 to 6 weeks our sales associates receive an "Internal License Error CWBLM001" when they attempt to logon the system. They only way to get the error to go away is to give admin rights, logon to...

Clickster30 pointsBadges:

ODBC Connection to iSeries

Hi, My company has just upgraded to V6RM0 of iSries and I have had problems connecting to the new server through ODBC using Crystal Reports or SQL server DTS. The packages I already had set up are still functioning and I can get a connection OK, but whern I try to create a new package I get an a...

MBell40 pointsBadges:

iSeries Access for Web

I just read the 'iSeries Access for Web tutorial' I followed the instructions and it seems that I was able to configure everything successfully. However when I try to access the URL I get a 'Error 404' Can someone please tell me what I may have done wrong.

Mprice5 pointsBadges:

iSeries Access printing with Lexmark 2381 printer

Hi We have a client using IBM Power 6 Server with Os/400 V5R4 using Iseries Acces version 6 to control a Lexmark 2381 printer contected to a P.C. The problem we are having is we are trying to print an 8 1/2 " form (51 lines) and the first form prints fine (Continuese forms) but at the end of the...

Semd041970 pointsBadges:

transferring data from iSeries to Excel 2007

Using the Excel 2007 add-in for the iSeries data transfer, is there a way to transfer into the spreadsheet more then 65,000 rows?

Popers40 pointsBadges:

Customize Epson 9 pin with TRANSFORM(*NO)

Greetings, is it possible to customize a Epson 9 pin connected to a PC with iSeries Access V5R4 with the TRANSFORM(*NO.)? I'm trying using a customization object (WSCST) and haven't had any positive results.

AS400 - Ask the Expert485 pointsBadges:

Mapping to IFS from another domain

Iseries and AD profiles are synch'd for mapping IFS Shares. We now have other users from another domain accessing the shares, If the get the windows Signo window what need to be inputted?

Rickmcd1,720 pointsBadges:

iSeries Access disconnecting on Vista

I work in an environment where most folks use iSeries Access and have no problems. However, my session gets disconnected after only a few minutes of inactivity. Another user also gets disconnected although he has told me that it even disconnected while he was using the session. His PC operating...

AS400 - Ask the Expert485 pointsBadges:

Using Access Codes with iSeries

We are using Access Codes to keep track of our color printing, but when we have that feature activated we cannot print from the AS400. Has anyone been able to print to AS400 and keep the Access Code feature activated?

Rhurley465 pointsBadges:

Client Access Upgrade v5r3 – v5r4 XLS and Printer file issues

We are upgrading OS to V5R4 from V5R3. We are leaving Client Access (iseries access) at present level of V5R3. Can anyone clarify expectations or issues that may be encountered. Was told XLS a little different; and may some print file issues.

Gambitt7160 pointsBadges:

iSeries Access For Web – Run SQL Function

Hi Has anyone had the problem where iSeries Access For Web does not run some SQL features consistently? I have a customer that is using this to provide reports from the iSeries to his customers. Customers can log onto the iSeries from the web and get to run reports already created. The customer can...

Riccardo95 pointsBadges: