Hi, I’m trying to copy tables from Access 2007 into DB2 for i5/OS. I’m connecting to the Access DB via HXTT Access Client driver and the i5 via the JTOpen(AS/400) driver. The problem is when I copy a table from Access to i5, it only copies 1,000 records. I get a message that the copy was successful, but it only copies the 1st 1,000 records. I tried changing around some settings, but nothing seems to help. Any suggestions? Thank you!

 

 

If you have any questions, please contact me.

 

Thank you,

Vincent Visconti
Database Analyst/Programmer
Sound Recording Special Payments Fund
570 Lexington Avenue, 21st Floor
New York, NY 10022-6837
Phone: 212-310-9429
e-mail: vvisconti@sound-recording.org