× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi David,

Assuming you're on Windows XP and have iSeries Access and MS Access installed:
- start MS Access
- open a database or create a new one
- create a new table, selecting Link table
- in the File open window, select Files of type: ODBC Databases. This will open a "Select Data Source" window.
- select an existing ODBC data source for your iSeries, or click on the New button.
- if you clicked on the button for a new ODBC data source,
. select the Client Access ODBC driver or iSeries Access ODBC driver (on my PC they're the same CWBODBC.dll dated 12/3/2004.).
. make up a name for the data source and tell it where to save it; the default location is simplest.
. click Finish and you'll get to the data source options window.
- under the General tab, be sure to select your iSeries system.
- under the Server tab, select SQL naming convention, your default library, etc. Also (as Steve Landess mentioned) click on the Advanced button and set the Commit mode to "Commit immediate (*NONE)".
- under the Translation tab, check the "Convert binary data" check box.
- click Ok.
. click Ok

You should now see a list of tables in the library you selected when setting up the data source. Select one by clicking on it, then click Ok. You'll get a list of fields in the table for you to identify the unique key. After you click Ok on that, you have an Access table linked to your iSeries table. You can now create SELECT, INSERT, UPDATE, DELETE queries over that table.

Contrary to John Arnold's experiences, I had no problem today doing an INSERT INTO from a local Access table to a linked table on a v4r4 system and on a v5r4 system using iSeries Access v5r3m0 and MS Access 2000.

*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /

David FOXWELL wrote:
I would like to know how to do this. Could someone explain please ?

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de tim
Envoyé : mardi 6 mai 2008 22:49
À : 'Midrange Systems Technical Discussion'
Objet : best way to copy records from ms access to iseries

I am trying to copy a table from MS access to the iseries. The table defs are the same on both systems. I've tried "insert into" sql, but I get an error saying "ODBC insert on a linked table failed. Iseries ODBC driver not valid for operation.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.