Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002

    Unanswered: Importing and updating Tables?

    I am trying to import a table from another database and then update a table in the current database. To do this I am using the transfer database function in a macro into a new table. I am then using an update query to update the records from the imported table to the local table. The problem is, when there is a field in the imported table that contains a null value, I don't want to update that field. It is not feasible to make all fields have a required entry, by setting the field properties. I tried to use a iif statement but all I can do is input a space if it is null and that erases the current data in that field. This is what I want to avoid. Sorry this is so long winded. Thanks in advance for any help.

  2. #2
    Join Date
    Nov 2002
    Update the fields using fields in recordset then you can condition when you are updating the fields by checking the length of the incoming field > 0.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts