Toad World® Forums

Error on FK columns, data type on import from Excel

Hi all,

I have a problem with importing data from Excel (Comments). Whenever I do an export and then an import I get errors on all FK columns as in image below. There were no changes in the Excel. Just Export - Import of the same file.

Is there something that I’m doing wrong? TDM version is 5.5.

Error_on_FK.png

I’ve tried the same thing with CSV and I get the same result.

Has anyone had any similar experience with this?

Thanks,

Ivan

Hi,

Export and import should work correctly.
Please, can you send us the model and exported excel file to modeling@quest.com?

We will test it and let you know our findings.

Thank you,

Vaclav

Hi,

I’ve sent you the model and Excel file.

Thanks,

Ivan

Hi Ivan,

There was an error in the import process that was fixed as a part of TDM 6.0 development. Please try it again in Toad Data Modeler 6.0 which was just released a couple of days ago.

Regards,

Lukas

Thanks, I will try in in the next few days.

BR,

Ivan