Import 123 worksheet as "response document"

I do not think you can do that without programming an agent.
The regular Notes File Import option is incapable of doing that, for sure.
I would start by creating a key for the main documents that exist, and including that key for each document to import (each line in the worksheet).
Then I would save the worksheet in text format with a defined seperator.
After that, I would write an agent in script that would go line by line, get the main doc identified by the key, and create a response with the rest of the data.
A lot of work, but I do not see any other way to import responses reliably.

Pascal.

Pascal,

I have found another way to do it, I have first import my 123 file and after that I have change the $ref value.

thanks anyway for your idea..

cheers

Julie