Import Manager

[Former Member]

Can anyone help on Import Manager.

I have Access file in which there are some Lookup data, when I am importing I have to select manually data to map from source to destination. Is there any way that this can be done automatically?

[Former Member]

Hi Ritesh,

Save the import map and you should be able to execute this operation automatically from next time.

Select toolbar and hit File--> Save Map.

Regards,

Mir

[Former Member]

Hi Mir,

    Thanks, but I think you misunderstood the question.

My question is when I am importing the lookup data it is not automatically mapping and after completion of import the lookup data is not importing rest without lookup field data is importing properly.

[Former Member]

You might need to check if the values are already available in Lookup table, if not you must add those values in lookup table.

Secondly if you are mapping though a main table and looping into lookup main field, then these values should be available in remote keys of lookup main field.

Please let me know if this works!