Re: Transfer Access Database tables to ISERIES

It's been awhile since I've messed with Access and the iSeries but you
should be able to do it with ODBC.  First create a file on the iSeries with
the appropriate fields, sizes, and such.  Then using the iSeries/Access
ODBC driver on your PC create a link table in Access, and then create an
update query in Access (I think that was the name) that will write records
to the iSeries via ODBC.



Dave Parnin
--
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxx




                                                                                
                                                          
                      "Smith, Mike"                                             
                                                          
                      <Mike_Smith@RGCResou        To:       
<midrange-l@xxxxxxxxxxxx>                                                     
                      rces.com>                   cc:                           
                                                          
                      Sent by:                    Subject:  Transfer Access 
Database tables to ISERIES                                    
                      midrange-l-bounces@m                                      
                                                          
                      idrange.com                                               
                                                          
                                                                                
                                                          
                                                                                
                                                          
                      09/07/2006 03:09 PM                                       
                                                          
                      Please respond to                                         
                                                          
                      Midrange Systems                                          
                                                          
                      Technical Discussion                                      
                                                          
                                                                                
                                                          




I need to transfer several tables from an Access Database- I know, I
know.  Theres not any chance any time soon of the Access being replaced
as it is from a vendor product.

Anyway this has to be an automated process on a quarterly
basis(preferably kicked off from the ISERIES.

I don't see a way to do this with Client Access.

Any ideas on how to accomplish this?

Michael Smith
iSeries.mySeries.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.