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.
Sound Recording Special Payments Fund
570 Lexington Avenue, 21st Floor
New York, NY 10022-6837