Access -> Navision

Hi, Can someone tell me how to manage the import of values () from an Access 2002 table to a Navision table. It works only with Numeric Access data type, and with text data type, I get an error with empty fields. I’m using “Microsoft ActiveX Data Objects 2.6 Library”. Thank You

In sql statement, subtsitute null by ‘’ or 0, o create new table and “clear” nulls via ‘’ or 0. Best regards from BCN. Salut!