Null error with copy/paste function--Access table with iSeries

[Guest.Visitor]

If you have any blanks or nulls in any fields, you might try putting in a space or something like that. Of you could export your test table to the iSeries, which should create it with the right data types (according to Access ;-)). Brian

[Diane Mueller]

I created a test table in MSACCESS and also a table with a "link" from an iSeries PF. Both tables having identical fields & sizes, when I copy from my "test table" and try to paste to the "link table", I receive this error: "You tried to assign the Null value to a variable that is not a variant data type." All data types in both the test and linked table are text types. Any thoughts? Diane

[Diane Mueller]

Brian, You're right, add the spaces and it's working fine. Thanks for the help. Diane